sql 发生死锁
SELECT request_session_id spid , OBJECT_NAME(resource_associated_entity_id) tableName FROM sys.dm_tran_locks WHERE resource_type = ‘OBJECT ‘; KILL 70;
温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/15801.html
SELECT request_session_id spid , OBJECT_NAME(resource_associated_entity_id) tableName FROM sys.dm_tran_locks WHERE resource_type = ‘OBJECT ‘; KILL 70;
温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/15801.html