1 select request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName from sys.dm_tran_locks
2 where resource_type='OBJECT'
上面一句是查询死锁的表和进程Id
下面一句是杀~~~~。
kill spid
1 select request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName from sys.dm_tran_locks
2 where resource_type='OBJECT'
上面一句是查询死锁的表和进程Id
下面一句是杀~~~~。
kill spid
转载于:https://www.cnblogs.com/Tony-Shen/archive/2011/11/08/2241053.html