查询并杀死死锁

select * from sys.dm_tran_locks 找出死锁的request_session_id

然后 kill 'request_session_id' 如:kill 66

原文地址:https://www.cnblogs.com/zhuawang/p/2670888.html