cat enabling-read_committed_snapshot-on-an-existing-mssql-database.md
Enabling read_committed_snapshot on an existing MSSQL database
In short, for the database named "internal":
SELECT is_read_committed_snapshot_on,snapshot_isolation_state FROM sys.databases WHERE name='internal'
ALTER DATABASE [internal] SET allow_snapshot_isolation ON
ALTER DATABASE [internal] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE [internal] SET read_committed_snapshot ON
ALTER DATABASE [internal] SET MULTI_USER
SELECT is_read_committed_snapshot_on,snapshot_isolation_state FROM sys.databases WHERE name='internal'
Comments