摘要: -- ================================================-- Template generated from Template Explorer using:-- Create Procedure (New Menu).SQL---- Use the S... 阅读全文
posted @ 2015-08-22 15:44 徐本县 阅读(173) 评论(0) 推荐(0) 编辑
摘要: exec dbo.sp_who_lock --查看当前死锁进程exec dbo.p_killspid db --杀掉引起死锁的进程create procedure sp_who_lock as begin declare @spid int,@bl int, @intTransactionC... 阅读全文
posted @ 2015-08-22 15:41 徐本县 阅读(1339) 评论(0) 推荐(0) 编辑