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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-20 : 08:42:01
|
| desi writes "hey guys,i implemented the mskb stored procedure EXEC master.dbo.sp_blocker_pss80which basically identifies the id at the head of the blocking chain.i was wondering if there is a stored procedure that could find out the head of the blocking chain then execute a kill (id) on it.sometimes i am out of the office away from a computer, so it would be helpful to have a simple sp to run.thanks.." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-20 : 13:23:03
|
| Put the results of the stored procedure into a table using INSERT INTO/EXEC. You can then loop through this table and issue a KILL per spid.Tara Kizeraka tduggan |
 |
|
|
|
|
|
sql 2000 blocking.