关于sqlserver:无法分离数据库解决方案

use master
go
create proc killspid (@dbname varchar(20))
as
begin
declare @sql nvarchar(500),@temp varchar(1000)
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

  set   @temp='kill     '+rtrim(@spid)   
  exec(@temp)   

fetch next from getspid into @spid
end
close getspid
deallocate getspid
end

–用法
use master
exec killspid ‘数据库名称’