Changing the transaction isolation level
Published 30 July 2015
When doing a Get Latest, by default SQL Source Control uses the READ COMMITTED transaction isolation level. You can change this by editing a config file:
- Close Management Studio.
- Go to the SQL Source Control config files folder: %localappdata%\Red Gate\SQL Source Control 4
Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.
You can change the value in the
<TransactionIsolationLeveltags to one of these values:
READ UNCOMITTED READ COMMITTED REPEATABLE READ SNAPSHOT SERIALIZABLE
Ignoring any comments (indicated with
<!->), the final file should look like this:
<EngineOptions version="3" type="EngineOptions"> <TransactionIsolationLevel>SERIALIZABLE</TransactionIsolationLevel> </EngineOptions>
The example above doesn't include any extra lines you may have included. For example, you may have included additional lines to set up change logging.
- Save the file.
Getting latest will now use the transaction isolation level you specified.