database lock

USE master
EXEC sp_lock

select * from sys.sysprocesses where blocked<>0

DBCC INPUTBUFFER(120)

kill 120

原文地址:https://www.cnblogs.com/kedarui/p/3777246.html