Create a gist now

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT CONCAT('ALTER DATABASE [', name, '] SET READ_WRITE WITH NO_WAIT')
FROM sys.databases where is_read_only=1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment