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 |
sreehari
Starting Member
37 Posts |
Posted - 2006-06-01 : 12:48:13
|
HiOn a huge database, one user is executing update statement.This process is blocking the other prcesses like select on the same table.How to handle the situation..Thanks in advance. |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-01 : 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. |
|
|
|
|
|