Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locks ... how to identify
Message
From
05/03/2002 15:34:20
 
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00627928
Message ID:
00628636
Views:
12
Thank you... will use them when next locks occur.

>sp_who will give you the chain. The block column contains the SPID that is the blocker.
>
>sp_lock will return info about the locks held by various SPIDs.
>
>-Mike
Ben Rail
Business Solutions
LOGI.design
Previous
Reply
Map
View

Click here to load this message in the networking platform