Error 905

[alan]

I get a 905 error when starting sql server on two seperate databases.
The error is followed by the description - Unable to allocate a DBTABLE descriptor....

What is the cause? This happens after stopping and starting the server from server manager. The only fix was to drop and recreate the DBs. Is there another way?

Thanks
Alan

[Craig]

On 10/9/98 1:02:31 PM, alan wrote:
> I get a 905 error when starting sql server on two seperate databases.
The
> error is followed by the description - Unable to allocate a DBTABLE
> descriptor....

What is the cause? This happens after stopping and
> starting the server from server manager. The only fix was to drop and
> recreate the DBs. Is there another way?

Thanks
Alan
+++++++++++
Alan,

I would look at sp_configure and confirm your open databases parm is set high enough for the number of databases the server contains. The 905 makes it look like some configuration parm is exceeded.

Craig