How to close all connections to a MSSQL database

Monday, 5 September 2011

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

Jeanne21 September 2011 at 02:12
I didn't know where to find this info then kbaoom it was here.
ReplyDelete
Replies