USE
GO
/****** Object: StoredProcedure [dbo].[DBTools_Sys_KillSPID] Script Date: 2012/8/2 10:56:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*------------------------------------
-- 用途:
-- 项目名称:
-- 说明:
-- 时间:
-- 编写者:
--------------------------------------
-- 修改记录:
-- 编号 修改时间 修改人 修改原因 修改标注
------------------------------------*/
/* 测试语句
exec [DBTools_Sys_KillSPID] 'NIRLOG200201'
*/
ALTER PROCEDURE [dbo].[DBTools_Sys_KillSPID]
(
@DBName sysname --要关闭进程的数据库名
)
AS
SET NOCOUNT ON ;
DECLARE @SQL NVARCHAR(MAX)
DECLARE Cur_SPID CURSOR LOCAL FOR
SELECT SQL='KILL '+CAST(SPID AS NVARCHAR(30))
FROM MASTER..sysprocesses
WHERE DBID = DB_ID(@DBName)
OPEN Cur_SPID
FETCH NEXT FROM Cur_SPID INTO @SQL
WHILE @@FETCH_STATUS=0
BEGIN
EXEC(@SQL)
FETCH NEXT FROM Cur_SPID INTO @SQL
END
CLOSE Cur_SPID
DEALLOCATE Cur_SPID
杀掉SQL SERVER目标库的所有连接
最新推荐文章于 2021-03-18 07:25:29 发布