Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-03-07 : 17:34:06
|
| hi there i have a program that runs and blocks the table.I can see what table it is but is there a way i can find out exact what is blocked on by table to the record row? Thanks |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-07 : 17:41:20
|
| Take a look at sp_lock and syslockinfo in Books Online, and here for an enhanced version of sp_lockhttp://support.microsoft.com/kb/q255596/ |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-03-07 : 19:12:26
|
| Let me try that and see if i get the record its blocked onCheers |
|
|
|
|
|
|
Blocked process