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

--先在master中创建一个存储过程，用于干掉所有连接，然后调用

use   master

exec killspid   '出问题的数据库名'