示例代码：
select spid, blocked, status, hostname, program_name, hostprocess, cmd from sysprocesses where dbid = db_id(‘xxx‘) and blocked > 0 -- kill spid_xxx
SQL Server 死锁检查
原文：http://www.cnblogs.com/xuejiancun/p/4082965.html
