分享：终止某指定
数据库的所有进程
[sql]
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