2014
12-26
12-26
Sql解锁 数据库死锁检测
USE[DataBaseName]GO/******Object: StoredProcedure[dbo].[sp_check_deadlock] ScriptDate:07/04/201413:49:30******/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOALTERprocedure[dbo].[sp_check_deadlock] assetnocounton /* select spidAs被锁进程ID, blockedAs锁进程ID, status As被锁状态, SUBSTRING(SUS...
继续阅读 >