i often use something more simple
DECLARE @TARGET INT
WHILE 1=1
BEGIN
DECLARE KILLCONS CURSOR LOCAL FAST_FORWARD FOR
SELECT SPID FROM MASTER..SYSPROCESSES WHERE DBID = DB_ID('DB NAME') AND SPID >=50
OPEN KILLCONS
FETCH NEXT FROM KILLCONS INTO @TARGET
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('KILL '+@TARGET)
FETCH NEXT FROM KILLCONS INTO @TARGET
END
CLOSE KILLCONS
DEALLOCATE KILLCONS
END
the infinite while is to take care of pesky applications that keep reconnecting, so you just manually break the loop when you feel like it
--
Thiago Dantas
@DantHimself