KillAllConnections.sql

USE [master]

DECLARE @dbname SYSNAME
SET @dbname = 'DATABASENAME'

DECLARE @spid INT
SELECT @spid = MIN([spid]) FROM [master].[dbo].[sysprocesses] WHERE [dbid] = DB_ID(@dbname)

WHILE @spid IS NOT NULL
BEGIN
    EXECUTE ('KILL ' + @spid)
    SELECT @spid = MIN(spid) FROM [master].[dbo].[sysprocesses] WHERE [dbid] = DB_ID(@dbname) AND [spid] > @spid
END