USE master
EXEC sp_lock
select * from sys.sysprocesses where blocked<>0
DBCC INPUTBUFFER(120)
kill 120
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