檢視鎖表

weixin_30488085發表於2020-04-06
SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName
FROM sys.dm_tran_locks
WHERE resource_type='OBJECT '
kill

轉載於:https://www.cnblogs.com/sandy_liao/archive/2012/03/22/2411508.html

相關文章