Categories
Databases

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

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