database lock

USE master
EXEC sp_lock

select * from sys.sysprocesses where blocked<>0

DBCC INPUTBUFFER(120)

kill 120