Pages

Ads 468x60px

Social Icons

Featured Posts

Search

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
 

Most Popular