关闭数据库下的所有连接操作 sql存储过程

usemastergo 
create  proc  KillSpByDbName(@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)opengetspidfetch  next  from  getspid  into  @spid  
while  @@fetch_status <>-1  
begin  
  set @temp='kill'+rtrim(@spid)exec(@temp)fetch  next  from  getspid  into  @spid  
end  
closegetspiddeallocategetspidend  

--举例使用，关闭数据库下的所有连接操作
UsemasterExec  KillSpByDbName  'bafangmsh'