Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Set a given DB back to multi user mode when locked by a given SPID
kill <SPID>
USE [master]
ALTER DATABASE <DBName>
SET MULTI_USER
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.