SQL Source Control 7

Change the transaction isolation level

When getting changes, 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 7
  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:

    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.

  5. Save the file.

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


Didn't find what you were looking for?