Harriet_Kim_1764

How to Determine if Versioning is Enabled on SQL Database

Discussion created by Harriet_Kim_1764 on Apr 7, 2017
Latest reply on Oct 19, 2017 by Christian_Boeck_57
Scenario:
A user's AE database on the MS SQL server is experiencing deadlocks.

Solution:
Verify if versioning is enabled:

SELECT is_read_committed_snapshot_on FROM sys.databases  WHERE name= 'YourDatabaseName'

To enable:
alter database database name set READ_COMMITTED_SNAPSHOT ON

For more details, refer to the documentation.


Outcomes