Categories
Server Administration

Kill All Active Database Connections

USE Master

ALTER DATABASE YourDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

ALTER DATABASE YourDatabase SET MULTI_USER

See Kill All Active Connections To A Database

Leave a Reply

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