select * from sysprocesses where blocked <> 0 
or spid in (select blocked from sysprocesses where blocked <> 0) 
go 
DBCC INPUTBUFFER (65) 

--KILL 65 --WITH STATUSONLY 

select * from sysprocesses where cmd = 'DBCC' 
select * from sysdatabases