分享：终止某指定数据库的所有进程

最新推荐文章于 2022-12-05 17:27:35 发布

置顶弘恩

最新推荐文章于 2022-12-05 17:27:35 发布

阅读量802

点赞数

本文链接：https://blog.csdn.net/c_enhui/article/details/8789811

版权

USE master 
go 
IF EXISTS ( SELECT 1 FROM sys.objects WHERE object_id = object_id ('sp_kill_db','P'))
DROP PROC sp_kill_db
go 
CREATE PROC sp_kill_db ( @db NVARCHAR(128) )
AS 
    DECLARE @sql_kill NVARCHAR(MAX) = ''
    SELECT  @sql_kill = @sql_kill + ' KILL ' + CAST(spid AS VARCHAR) + ' '
    FROM    sys.sysprocesses
    WHERE   spid > 50
            AND dbid = DB_ID(@db)
    EXEC sp_executesql @sql_kill ;

go 

EXEC sp_ms_marksystemobject 'sp_kill_db'
GO