--Kill All Blocked Transactions
use master
DECLARE @pid varchar(255)
DECLARE MY_CURSOR Cursor FOR
select distinct req_transactionUOW
from syslockinfo
WHERE req_spid=-2 and req_transactionUOW <> '00000000-0000-0000-0000-000000000000'
OPEN MY_CURSOR
FETCH FROM MY_CURSOR
INTO @pid
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'KILL ''' + @pid + ''''
exec ('KILL ''' + @pid + '''')
FETCH FROM MY_CURSOR
INTO @pid
END
CLOSE MY_CURSOR
DEALLOCATE MY_CURSOR