杀掉SQL SERVER目标库的所有连接

USE GO/****** Object:  StoredProcedure [dbo].[DBTools_Sys_KillSPID]    Script Date: 2012/8/2 10:56:20 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO/*-------------------------------------- 用途：-- 项目名称：-- 说明：-- 时间：-- 编写者: ---------------------------------------- 修改记录:-- 编号修改时间修改人修改原因修改标注------------------------------------*//*测试语句exec [DBTools_Sys_KillSPID] 'NIRLOG200201'*/ALTER PROCEDURE [dbo].[DBTools_Sys_KillSPID](@DBName sysname --要关闭进程的数据库名 ) ASSET NOCOUNT ON ;DECLARE @SQL NVARCHAR(MAX) DECLARE Cur_SPID CURSOR LOCAL FORSELECT SQL='KILL '+CAST(SPID AS NVARCHAR(30)) FROM MASTER..sysprocesses WHERE DBID = DB_ID(@DBName)OPEN Cur_SPIDFETCH NEXT FROM Cur_SPID INTO @SQL WHILE @@FETCH_STATUS=0 BEGIN EXEC(@SQL) FETCH NEXT FROM Cur_SPID INTO @SQL END CLOSE Cur_SPIDDEALLOCATE Cur_SPID