Kill all the current active connection in SQL Server database

There are times when you want to kill all the current active connections of your SQL Server database and you wish to run the database in the single user instance.

Here’s the query on how to do this.

use master
ALTER DATABASE <NameoftheDatabase> SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Once done with any changes , ensure that the MULTI_USER mode is enabled for the database.

ALTER DATABASE <NameoftheDatabase>  SET MULTI_USER

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply