sqlserver 批量kill死锁

select 'kill '+CONVERT(varchar,request_session_id) ,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks
where
resource_type='OBJECT'
原文地址:https://www.cnblogs.com/lvzhenHome/p/14031156.html