Posted by Scarab on 12/12/05 03:29

Hi,
When I drop a table in Sqlserver 2000 database, The following error occurs:

Server: Msg 1204, Level 19, State 1, Line 1
The SQL Server cannot obtain a LOCK resource at this time. Rerun your
statement when there are fewer active users or ask the system administrator
to check the SQL Server lock and memory configuration.


What's wrong? Any help is greatly appreciated, thanks.

[Back to original message]