杀掉死锁的sqlserver进程
SELECT request_session_id spid,OBJECT_NAME (resource_associated_entity_id)tableName FROM sys.dm_tran_locks WHERE resource_type='OBJECT ' KILL spid号
SELECT request_session_id spid,OBJECT_NAME (resource_associated_entity_id)tableName FROM sys.dm_tran_locks WHERE resource_type='OBJECT ' KILL spid号
转载于:https://www.cnblogs.com/zhuawang/p/3678912.html