--查询死锁 select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' --杀死死锁进程 kill 354 --显示死锁相关信息exec sp_who2 354
转自: SQLServer查询死锁 - Thinking.N - 博客园 (cnblogs.com)