How to Kill Active Connections to SQL Server database

Posted in SQL Server - 1 January 2012 - No comment
ALTER DATABASE databasename SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ALTER DATABASE databasename SET MULTI_USER