Posted by Scarab on 09/26/74 11:34

Thanks for your reply, how can i find out who is accesing the table? Thanks


"Greg D. Moore (Strider)" <mooregr_deleteth1s@greenms.com> wrote in message
news:pl6nf.2746$3Z.1361@newsread1.news.atl.earthlink.net...
>
> "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]