作者:admin 来源: 日期:2019/12/1 15:42:01 人气: 标签:
use master go
create proc KillSpByDbName(@dbname varchar(20))asbegindeclare @sql nvarchar(500),@temp varchar(1000)declare @spid intset @sql='declare getspid cursor for select spid from sysprocesses where dbid=db_id('''+@dbname+''')'exec (@sql)open getspidfetch next from getspid into @spidwhile @@fetch_status<>-1begin set @temp='kill '+rtrim(@spid) exec(@temp)fetch next from getspid into @spidendclose getspiddeallocate getspidend
Use master Exec KillSpByDbName '数据库名称'