...
- Log into SQL server management studio with an sa-level user account.
- Open a new query.
Run the following query to enable the READ_COMMITTED_SNAPSHOT option:
No Formatcode nopanellanguage truesql /** Run this statement to change the isolation level of the database. When the READ_COMMITTED_SNAPSHOT database option is set ON, the mechanisms used to support the option are activated immediately. When setting the READ_COMMITTED_SNAPSHOT option, only the connection executing the ALTER DATABASE command is allowed in the database. There must be no other open connection in the database until ALTER DATABASE is complete. The database does not have to be in single-user mode. **/ ALTER DATABASE APTIFY SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER DATABASE Aptify SET READ_COMMITTED_SNAPSHOT ON; ALTER DATABASE APTIFY SET MULTI_USER;
Run the following query to enable the ALLOW_SNAPSHOT_ISOLATION option:
No Formatcode nopanellanguage truesql /** Statement below can be used to turn on the snapshot isolation, so that transactions can set the snapshot isolation level. Per our analysis, there is no Aptify code that currently does this, therefore this is not required.**/ ALTER DATABASE Aptify SET ALLOW_SNAPSHOT_ISOLATION ON;Run the following query to verify the values of these options:
No Formatcode nopanellanguage truesql /** Query to determine snapshot states **/ SELECT Name , snapshot_isolation_state , snapshot_isolation_state_desc , is_read_committed_snapshot_on FROM sys.databases WHERE name = 'APTIFY';