SQL Source Control 4

Changing the transaction isolation level

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:

  1. Close Management Studio.
  2. Go to the SQL Source Control config files folder: %localappdata%\Red Gate\SQL Source Control 4
  3. Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.

  4. Inside the <EngineOptions> tags, add:

    <TransactionIsolationLevel>READ COMMITTED</TransactionIsolationLevel>

    You can change the value in the <TransactionIsolationLevel> tags to one of these values:


    Ignoring any comments (indicated with <!->), the final file should look like this:

    <EngineOptions version="3" type="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.

  5. Save the file.

Getting latest will now use the transaction isolation level you specified.

Didn't find what you were looking for?