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 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2008-03-05 : 11:34:53
|
| Can anyone guide me to write check block in SQL Server?I Mean if blocking occurs, just inform people. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-05 : 23:26:53
|
| By querying sysprocesses, check if blocked column has any > 0 value. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-07 : 14:16:56
|
| But i want to know who did blocking and sent email to people with spid and query that caused blocking |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-07 : 23:11:05
|
| You get those in sysprocesses. |
|
|
|
|
|
|
How to check block