sqlserver 数据库死锁sql

with seeLock(spid,yblocked,mblocked)
as
(
select a.spid,b.blocked,a.blocked from
 master..sysprocesses a,master..sysprocesses b
where a.blocked=b.spid and a.blocked>0
)
select spid,yblocked as blocked from seelock where yblocked>=0

 

查询数据库正在执行的操作，结果会比较多

select * from master.sys.sysprocesses where dbid=db_id()