mssql 数据库单用户无法变为多用户 提示数据库在某用户连接解决方法

摘要：USE [master] GO /****** Object: StoredProcedure [dbo].[killspid] Script Date: 03/28/2011 11:01:32 ******/ SET ANSI_NULLS ON GO…

USE [master] 
GO 
    
/****** Object:  StoredProcedure [dbo].[killspid]    Script Date: 03/28/2011 11:01:32 ******/ 
SET ANSI_NULLS ON
GO 
    
SET QUOTED_IDENTIFIER ON
GO 
    
  --建一个存储过程，断开所有用户连接。    
  create   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  
        
    
GO
  
  
  
use   master    
exec   killspid   '出问题的数据库名'
  
alter database 出问题的数据库名 set multi_user