Sunday, May 23, 2010

Clear all connections to a MSSQL database

Clear 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

No comments:

Post a Comment