You can check which statements are blocked by running this
1 2 |
select cmd,* from sys.sysprocesses where blocked > 0 |
You can check which statements are blocked by running this
1 2 |
select cmd,* from sys.sysprocesses where blocked > 0 |