27,582
社区成员




SELECT request_session_id AS spid ,
DB_NAME(resource_database_id) AS dbname ,
CASE WHEN resource_type = 'OBJECT' THEN OBJECT_NAME(resource_associated_entity_id)
WHEN resource_associated_entity_id = 0 THEN 'n/a'
ELSE OBJECT_NAME(p.object_id)
END AS entity_name ,
resource_type AS resource ,
request_mode AS mode ,
request_status AS status
FROM sys.dm_tran_locks t
LEFT JOIN sys.partitions p ON p.hobt_id = t.resource_associated_entity_id
WHERE resource_database_id = DB_ID() AND t.request_mode='X' AND t.request_status='GRANT'
AND OBJECT_ID('表名')=t.resource_associated_entity_id
--判断表上面有没有加上表的排它锁