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'

Leave a Reply

Your email address will not be published.