查询死锁进程语句select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT'杀死死锁进程语句kill spid下面再给大家分享一段关于sqlserver检测死锁;杀死锁和进..
复制代码 代码如下:USE masterDECLARE @spid intDECLARE CUR CURSORFOR SELECT spid FROM sysprocesses WHERE dbid = 5FETCH NEXT FROM CUR INTO @spidWHILE @@FETCH_STATUS = 0BEGIN--EXEC ('KILL ' + @spid )FETCH NEXT FROM CUR INTO @spidENDCL..