Great job!

In the usp_KillConnections procedure, why not turn the DB to SINGLE_USER ?

ALTER DATABASE [DB NAME] SET SINGLE_USER

WITH ROLLBACK IMMEDIATE

This will remove all current connections,

besides the SPid that your...

Hi,
Thank you for the quick tip.

I believe a follow up is in need.

In case the manager asks for a...