declare @spid int,

@sqlstm nvarchar(120)

DECLARE processes_cursor CURSOR FOR

select spid

from master.dbo.sysprocesses

where spid >= 0 and spid <= 32767 and spid <> @@spid and kpid <> 0

and spid in (select distinct blocked from master.dbo.sysprocesses where blocked <> 0)

OPEN processes_cursor

FETCH NEXT FROM processes_cursor INTO @spid

WHILE @@FETCH_STATUS = 0

BEGIN

set @sqlstm = 'kill '+CONVERT(varchar(3), @spid)

exec sp_executesql @sqlstm

FETCH NEXT FROM processes_cursor INTO @spid

END

CLOSE processes_cursor

DEALLOCATE processes_cursor