select
'kill '+convert(nvarchar(50),request_session_id) [复制SQL出来执行语句(杀锁表ID)],
request_session_id 标识,
OBJECT_NAME(resource_associated_entity_id) 表名
FROM
sys.dm_tran_locks
where
resource_type=‘OBJECT’
执行,复制结果第一列,执行
select
'kill '+convert(nvarchar(50),request_session_id) [复制SQL出来执行语句(杀锁表ID)],
request_session_id 标识,
OBJECT_NAME(resource_associated_entity_id) 表名
FROM
sys.dm_tran_locks
where
resource_type=‘OBJECT’
执行,复制结果第一列,执行