Kill all the current active connection in SQL Server database

Your 2020 Plan. Learn 20 minutes a day for 20 days. Online courses from €9.99.

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

Leave a Reply

Your email address will not be published. Required fields are marked *