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
分享:终止某指定数据库的所有进程
最新推荐文章于 2023-02-01 19:14:41 发布