用于asp.net还原与恢复sqlserver数据库的killspid存储过程

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 db/default/index/url?u=aHR0cHM6Ly93d3cuY25ibG9ncy5jb21tYWlsdG86JycnK0BkYm5hbWUrJycnKSc=" rel="nofollow" target="_blank">'''+@dbname+''')'

exec (@sql)

open getspid

fetch next from getspid into @spid

while @@fetch_status<>-1

begin

exec('kill '+@spid)

fetch next from getspid into @spid

end

close getspid

deallocate getspid

end

GO