Monthly Archives: September 2011
How to close all connections to a MSSQL database
| September 5, 2011 | Posted by Matt under Uncategorized |
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
I am IT professional with over 10 years of experience in computer programming and web development, specializing in Microsoft technologies.
Recent Comments