umair-me/close_all_connections.sql

Last active January 19, 2016 16:07

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/umair-me/da575870e8693e96df90.js"></script>
Save umair-me/da575870e8693e96df90 to your computer and use it in GitHub Desktop.

Download ZIP

Close all connections SQL server database

Raw

close_all_connections.sql

	USE master
	GO
	ALTER DATABASE YourDatabaseName
	SET OFFLINE WITH ROLLBACK IMMEDIATE
	GO

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment