• 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