Posted by Greg D. Moore \(Strider\) on 12/12/05 05:43

"Scarab" <yw@lucent.com> wrote in message
news:dnijpb$f0k@netnews.net.lucent.com...
> 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.
>

Someone else is accessing the table.


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

[Back to original message]