Clear all connections to a MSSQL database

25 July 2009 14:58 | coldfusion, mssql

Simple script to close all connections to a MSSQL database.

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

Comments (0) | Send | del.icio.us | Digg It! | Linking Blogs | 1482 Views
Add a comment
(will not be published)
(include http://)