|
nr
SQLTeam MVY
United Kingdom
12543 Posts |
 Posted - 06/01/2006 : 13:02:50
|
You can release the other processes by killing the blocking one - it will roll back any changes that are in progress.
It's up to you to decide whether that will cause problems.
Add this sp to master and run it regularly - it will show you running processes and commands and blocking commands.
http://www.nigelrivett.net/SQLAdmin/sp_nrInfo.html
==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
how to deal with blocking processes
