Home » Uncategorized » How to close all connections to a MSSQL database

How to close all connections to a MSSQL database

September 5, 2011

Posted by Matt under Uncategorized

1 Comment

This script closes all connections to MS SQL database

USE master;
GO
ALTER DATABASE dbName
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE dbName
SET MULTI_USER;
GO

JeanneSeptember 21, 2011 at 1:12 am

I didn’t know where to find this info then kbaoom it was here.

Reply