杀死数据库进程还原数据库

USE [master]
GO
/****** 对象: StoredProcedure [dbo].[KillSpId] 脚本日期: 04/17/2014 16:51:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER proc [dbo].[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 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

转载于:https://www.cnblogs.com/sijiyong/p/3671165.html