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:
   

   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.