SQL Server Blocking DBCC Inputbuffer Script

SELECT spid,dbid,DB_NAME(dbid),status,hostname,program_name,*


FROM MASTER.SYS.sysprocesses

WHERE blocked <>0

GO

SELECT 'DBCC INPUTBUFFER(' + CAST(spid AS VARCHAR) + ')' ,dbid,DB_NAME(dbid),status,hostname,program_name

FROM MASTER.SYS.sysprocesses

WHERE blocked <>0

GO

SELECT 'KILL ' + CAST(spid AS VARCHAR) + ';GO' ,dbid,DB_NAME(dbid),status,hostname,program_name

FROM MASTER.SYS.sysprocesses

WHERE blocked <>0

DBCC INPUTBUFFER(70)