-- 查询死锁
select
request_session_id spid,
OBJECT_NAME(resource_associated_entity_id) tableName
from
sys.dm_tran_locks
where
resource_type=‘OBJECT‘
---删除锁
KILL 79 ---spid
原文：https://www.cnblogs.com/puzi0315/p/11264488.html