farukaf/SwitchSingleMultiUser

Created August 2, 2021 17:28

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

Download ZIP

Switch SQL Server SingleUser/MultiUser to cut open connections

Raw

SwitchSingleMultiUser

	USE DBNAME

	GO

	ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE

	GO

	ALTER DATABASE DBNAME SET MULTI_USER WITH ROLLBACK IMMEDIATE

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