杀死进程的存储过程.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