It is still snowy and cold outside so short post today about killing connections. I love this quick little script and can’t remember where I got it from, so huge Thank You to the person that created it. I use it when I need to restore a database that still has active connections. This will first print a list of the connections it wants to kill for the database in the where clause, if you uncomment the “EXEC” part, you will get the fastest connection killer you have ever used.
DECLARE @SQL VARCHAR(8000)
SELECT @SQL=COALESCE(@SQL,'')+'Kill '+CAST(spid AS VARCHAR(10))+ '; '
--EXEC(@SQL) /*Replace the print statement with exec to execute*/
Enjoy and Have a Magical Day!