Subscribe to our YouTube Channel for more Videos

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

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.