【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了杀死进程的存储过程.sql相关资料,希望对各位网友有所帮助!
use master
go
create proc killspid
(
@dbname varchar(50)
)
as
begin
declare @sql nvarchar(500)
declare @spid int
set @
sql='declare getspid cursor for
select spid from sysprocesses where dbid=db_id('+@dbname+')'
print @sql
exec (@sql)
open getspid
fetch next from getspid into @spid
while @@FETCH_STATUS<>-1
begin
print @spid
exec ('kill '+@spid)
fetch next from getspid into @spid
end
close getspid
deallocate getspid
print 'OK'
end