kill em todos os processos do db

Use com moderacao...

Este script "mata" todos os processos do db.

SET NOCOUNT ON
DECLARE @spidstr varchar(8000)
DECLARE @ConnKilled smallint
DECLARE @DBName AS VARCHAR(50)
DECLARE @withmsg AS BIT =1

SET @DBName = DB_NAME()
SET @ConnKilled=0
SET @spidstr = ''

IF db_id(@DBName) < 4
BEGIN
PRINT 'Processos do Sistema'
RETURN
END

SELECT @spidstr=coalesce(@spidstr,',' )+'kill '+convert(varchar, spid)+ '; '
FROM master..sysprocesses WHERE dbid=db_id(@DBName)

IF LEN(@spidstr) > 0
BEGIN
EXEC(@spidstr)

SELECT @ConnKilled = COUNT(1)
FROM master..sysprocesses WHERE dbid=db_id(@DBName)

END

IF @withmsg =1
PRINT CONVERT(VARCHAR(10), @ConnKilled) + ' Connection(s) killed for DB ' + @DBName
GO