Script para eliminar las conecciones de la Base de datos

DECLARE @dbname nvarchar(128)
SET @dbname = 'NOMBRE DE LA BASE DE DATOS'
DECLARE @processid int 
SELECT @processid = min(spid) 
from master.dbo.sysprocesses 
where dbid = db_id(@dbname) 
WHILE @processid IS NOT NULL 
BEGIN 
EXEC ('KILL ' + @processid) 
SELECT @processid = min(spid) 
from master.dbo.sysprocesses 
where dbid = db_id(@dbname) 
END