Skip to content

Instantly share code, notes, and snippets.

@cemerson

cemerson/sql-database-onlineoffline-readonly-queries.sql

Created February 14, 2025 10:55
Show Gist options
  • Save cemerson/ec72258f4729c8c390594637bb016750 to your computer and use it in GitHub Desktop.
Save cemerson/ec72258f4729c8c390594637bb016750 to your computer and use it in GitHub Desktop.
Download ZIP
sql-database-onlineoffline-readonly-queries.sql
Raw
sql-database-onlineoffline-readonly-queries.sql
-- ALTER DATABASE MyDB SET READ_WRITE;
ALTER DATABASE MyDB SET OFFLINE WITH ROLLBACK IMMEDIATE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment