sqlserver查看有没有锁表
SELECT request_session_id,OBJECT_NAME(resource_associated_entity_id) tablename(锁表的表名) from sys.dm_tran_locks where resource_type=‘object’
sqlserver查看有没有被锁的表
最新推荐文章于 2024-07-06 08:00:00 发布
sqlserver查看有没有锁表
SELECT request_session_id,OBJECT_NAME(resource_associated_entity_id) tablename(锁表的表名) from sys.dm_tran_locks where resource_type=‘object’