>Does anyone have a solution to this problem? I have four SQL2000 servers, 2 with a smallish number of databases (under 200) and 2 with many more databases (over 1 thousand). The servers with the smaller number of databases on them run my optimization jobs just fine. The servers with the large number of databases chrashes when I optimize all user tables. When I select anywhere from 150 - 250 databases it works just fine. The crash is a memory allocation error and requires a reboot. Dividing the optimization job up into smaller jobs isn't really an option as the number of databases grows continually. We never delete records out of our databases, only mark them as deleted (legal issues there) so is database optimization even needed? Any suggestions would be appreciated.

John;

I do not have the answer to your question but I would hate to have 1000 databases on one of our servers. We have 50 on one server and it takes a minute to open them using the Enterprise Manager. On my local machine I have 5 and it takes a second or two.

Do you have enough memory or a bad memory chip by chance?

Tom