解除死锁

select
request_session_id spid,
OBJECT_NAME(resource_associated_entity_id) tableName
from
sys.dm_tran_locks
where
resource_type='OBJECT'


kill 59

posted @ 2020-06-06 17:24  liangyuwen  阅读(114)  评论(0编辑  收藏  举报