error 910 in sql server 6.5

[msloan]

I have not been able to find much documentation for Error 910 - Could not allocate a new object description for required system catalog database...

Any information about the cause, solution etc. is greatly appreciated.

Thanks

Matt

 

[Ruairi]

run sp_configure in the querey window and look at the configured value of "open objects". This is how many 'objects' (tables, indexes, etc..) SQL Server can have open at one time. If it is at the limit it can be prevented from opening any more objects needed to complete a task. I don't really know what a good value is, mine is configured at 20,000 which is a number i reached through trial and error. The other time i have seen that kind of error is if you are running out of data or log space. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com