-- Script returns blocking information from the sysprocesses table
SELECT spid, blocked, status, waittime,
waittype, waitresource, db_name(dbid) DatabaseName, cmd,
hostname, loginame
FROM master..sysprocesses
WHERE blocked != 0
DECLARE @spid int
-- Get the root blocker's spid id
SELECT @spid = A.spid
FROM master..sysprocesses A
INNER JOIN master..sysprocesses B
ON A.spid = B.blocked
WHERE A.blocked = 0
IF NOT @spid IS NULL
BEGIN
-- Returns last statement sent from the connection
DBCC INPUTBUFFER(@spid)
END
因篇幅问题不能全部显示，请点此查看更多更全内容