How to Kill Active Connections to SQL Server database Posted bydmytro January 1, 2012February 12, 2012 ALTER DATABASE databasename SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE databasename SET MULTI_USER