Skip to content

Instantly share code, notes, and snippets.

@RickyLin

RickyLin/READ_COMMITTED_SNAPSHOT.sql

Last active May 26, 2022 03:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RickyLin/3a77a69e2664db0b2c1777dfbd7fa43d to your computer and use it in GitHub Desktop.
Save RickyLin/3a77a69e2664db0b2c1777dfbd7fa43d to your computer and use it in GitHub Desktop.
Download ZIP
Set READ_COMMITTED_SNAPSHOT on for a database.
Raw
READ_COMMITTED_SNAPSHOT.sql
ALTER DATABASE DatabaseName SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE DatabaseName SET READ_COMMITTED_SNAPSHOT ON
ALTER DATABASE DatabaseName SET ONLINE
/* Generate sql scripts for multiple databases.
SELECT 'ALTER DATABASE ' + [name] + ' SET OFFLINE WITH ROLLBACK IMMEDIATE;
ALTER DATABASE ' + [name] + ' SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE ' + [name] + ' SET ONLINE;
'
FROM sys.databases
WHERE [name] LIKE '%whatever%'
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment