SQL SERVER查詢鎖

with Lock(level, dbName,spid,blocked,sql_handle)   as   (select 0 as level, db_name(dbid),spid,blocked,sql_handle from master..sysprocesses a where blocked > 0 union all select level + 1 as Level, db_name(a.dbid),a.spid,a.blocked,a.sql_handle from master..sysprocesses a join lock b on a.spid = b.blocked and a.spid <> a.blocked where level < 5)   select distinct a.level, a.dbName, a.spid, a.blocked, case when (a.blocked <> 0) then 'blocked' else 'blocker' end as actor, b.* from Lock a cross apply sys.dm_exec_sql_text(a.sql_handle)b order by actor desc