sql 发生死锁

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

KILL 70;

 

posted @ 2019-12-16 17:10  山顶洞外人  阅读(188)  评论(0编辑  收藏  举报