Posted by MC on 10/06/03 11:34

Try with sp_who2 stored procedure. Or use current activity in the EM.


MC


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

• Next in forum: Re: Database security
• Prev in forum: Re: Adding Time Totals in SQL
• Thread view: Re: Why I can't drop a table

[Reply to this message]