查找引起SQL SERVER死锁操作方法,希望大家探讨
use master
go
declare @spid int
--查询出死锁的SPID
select @spid=blocked
from (select * from sysprocesses where blocked>0 ) a
where not exists(select * from (select * from sysprocesses where blocked>0 ) b
where a.blocked=spid)
--输出引起死锁的操作
DBCC INPUTBUFFER (@spid)
--exec sp_who2