> I got the following message while trying to run updatecall.sql from
> Query since it just locks up under emerald admin.
> What does this mean and how do I fix it?
> Msg 1204, Level 19, State 3
> SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or ask your System Administrator to reconfigure SQL Server with more LOCKS.
> Msg 3701, Level 11, State 1
> Cannot drop the table '#temp_accountlist', because it doesn't exist in the system catalogs.
> Msg 3701, Level 11, State 1
> Cannot drop the table '#temp_serverlist', because it doesn't exist in the system catalogs.
You can up the number of database locks through sql 6.5's enterprise
manager. It's under Server\SQL Server\Configuration.
The database locks parts of itself to keep other processes from updating
the same thing or reading uncommited information. These ought to be run
at night when no other scheduled tasks are going.
Have Fun!
Peter
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart