rajanand/close database connection .sql

Last active December 30, 2015 13:49

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/rajanand/7837769.js"></script>
Save rajanand/7837769 to your computer and use it in GitHub Desktop.

Download ZIP

To close all the connection of a database in SQL Server.

Raw

close database connection .sql

	USE master

	GO
	ALTER DATABASE DatabaseName
	SET OFFLINE WITH ROLLBACK IMMEDIATE
	ALTER DATABASE DatabaseName
	SET ONLINE
	GO

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