Friday, February 13, 2015

SQL Server How to Drop Connections

ALTER DATABASE dbname
 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER DATABASE dbname
 SET MULTI_USER
GO