MS SQL Database

Snapshot Isolation

yuuvis® RAD requires its database to have a snapshot isolation level of "read committed". With the statements in the following two codeblocks you can determine the current snapshot isolation level (1st codeblock) and set the level to the required "read committed" (2nd codeblock).

Determine the current snapshot isolation level.

SELECT is_read_committed_snapshot_on, 
       snapshot_isolation_state_desc, 
       snapshot_isolation_state 
FROM sys.databases
WHERE name = '<dbname>'

Set snapshot isolation to "read committed"

ALTER DATABASE <database> SET SINGLE_USER WITH ROLLBACK IMMEDIATE ;
ALTER DATABASE <database> SET allow_snapshot_isolation ON;
ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE <database> SET MULTI_USER;