kill sql数据库死锁进程
摘要:
1 Create Proc Sp_KillAllProcessInDB 2 3 @DbName VarChar(100) 4 5 as 6 7 if db_id(@DbName) = Null 8 9 begin10 11 Print 'DataBase dose not Exist'12 13 end14 15 else16 17 18 Begin19 20 Declare @spId Varchar(30)21 22 23 DECLARE TmpCursor CURSOR FOR24 25 Select 'Kill ' + convert(Varchar, 阅读全文
posted @ 2011-09-05 15:51 sajiao 阅读(1533) 评论(0) 推荐(0) 编辑