如何查出SQL Server死锁的原因，下面就教您SQL Server死锁监控的语句写法,下面的SQL语句运行之后，便可以查找出SQLServer死锁和阻塞的源头

查找出SQLServer的死锁和阻塞的源头 –查找出SQLServer死锁和阻塞的源头 代码如下:use mastergodeclare spid int,bl intDECLARE s_cur CURSOR FORselect  0 ,blockedfrom (select * from sysprocesses where  blocked>0 ) awhere not exists(select * from (select * from sysprocesses where  b