Where the coders get together :): Process blocked

Showing posts with label Process blocked. Show all posts

Friday, February 4, 2011

Here is an easy way of finding the culprit and resolving :)

 select * from master..sysprocesses where blocked <> 0

dbcc inputbuffer(<processid>)

kill <processid>