-
Kill blocked process in SQL Server 2008
http://amitchandnz.wordpress.com/2010/08/29/kill-process-sp_who2/
Run sp_who2;
To kill a process just enter the word kill followed by the SPID:
kill SPID;
The field Blkby will identify the SPID that is causing any blocks.
