查询被锁的表

it2025-04-04  20

 

 

SELECT request_session_id spid, OBJECT_NAME( resource_associated_entity_id ) tableName FROM sys.dm_tran_locks WHERE resource_type = 'OBJECT' ORDER BY request_session_id ASC

  

转载于:https://www.cnblogs.com/lhlong/p/11112752.html

相关资源:南大通用GBase 8s双主故障分析处理案例.pdf
最新回复(0)