Shulou(Shulou.com)06/01 Report--

DECLARE @ spid INT

DECLARE @ blk INT

DECLARE @ count INT

DECLARE @ index INT

DECLARE @ lock TINYINT

SET @ lock=0

CREATE TABLE # temp_who_lock

(

Id INT IDENTITY (1,1)

Spid INT

Blk INT

)

-- if @ @ error0 return @ @ error

INSERT INTO # temp_who_lock

(spid

Blk)

SELECT 0

Blocked

FROM (SELECT

FROM master..sysprocesses

WHERE blocked > 0) a

WHERE NOT EXISTS (SELECT

FROM master..sysprocesses

WHERE a.blocked = spid

AND blocked > 0)

UNION

SELECT spid

Blocked

FROM master..sysprocesses

WHERE blocked > 0

-- if @ @ error0 return @ @ error

SELECT @ count = Count (*)

@ index = 1

FROM # temp_who_lock

-- select @ count,@index

-- if @ @ error0 return @ @ error

IF @ count = 0

BEGIN

SELECT'no blocking and deadlock information'

-- return 0

END

WHILE @ index @ index

AND EXISTS (SELECT 1

FROM # temp_who_lock

WHERE id

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.