> Kill connections is pretty good. <
No, it's not - ALTER DATABASE should be used.
And if you really want to issue specific KILLs, you can do it something like this:
DECLARE @sql VARCHAR(8000)
SET @sql = ''
SELECT @sql = @sql + 'KILL ' + CAST(spid AS VARCHAR(10)) + ' '
FROM sysprocesses WITH (NOLOCK)
WHERE spid > 50 AND DB_NAME(dbid) = N'databaseName'
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!