复制代码
–查询死锁
SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName
FROM sys.dm_tran_locks
WHERE resource_type='OBJECT ’
–杀死死锁
KILL 59
–显示死锁相关信息
exec sp_who2 59
复制代码
–查询死锁
SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName
FROM sys.dm_tran_locks
WHERE resource_type='OBJECT ’
–杀死死锁
KILL 59
–显示死锁相关信息
exec sp_who2 59