存储过程必须要创建在系统数据库的master里#from create proc killspid (@dbname varchar(20)) as begin declare @sql nvarchar(500) declare @spid int set @sql='declare getspid cursor for select spid from sysprocesses where dbid=db_id('''+@dbname+''')'exec (@sql)open getspidfetch next from getspid into @spid while @@fetch_status <> -1beginexec('kill '+@spid)fetch next from getspid into @spid end close getspiddeallocate getspid end
