SQL Server 2005 or 2008 provides several ways to find which sessions are currently working and which session is bleked some table.
SP_WHO, SP_WHO2 are two commands to finding out who are blocked.
Example: Open Sql Server 2005 or 2008 management Studio. Then type Sp_Who it dispalys like...
51 0 sleeping NT AUTHORITY\SYSTEM PRAKRIT25 0 msdb AWAITING COMMAND 0
0 indicates bloked status...
Same like who we have another option called Sp_who2
No comments:
Post a Comment