--检索死锁进程 select spid, blocked, loginame, last_batch, status, cmd, hostname, program_name from sysprocesses where spid in ( select blocked from sysprocesses where blocked <> 0 ) or (blocked <>0)捕捉堵塞进程 http://topic.csdn.net/u/20100928/17/64620fd2-eedc-4bd6-9d49-fcaf4385aab1.html?73854
select spid, blocked, loginame, last_batch, status, cmd, hostname, program_name
from sysprocesses
where spid in
( select blocked from sysprocesses where blocked <> 0 ) or (blocked <>0)捕捉堵塞进程
http://topic.csdn.net/u/20100928/17/64620fd2-eedc-4bd6-9d49-fcaf4385aab1.html?73854