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 6

3. Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.

4. Inside the <EngineOptions> tags, add:

   <TransactionIsolationLevel>REPEATABLE READ</TransactionIsolationLevel>

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

   READ UNCOMITTED

   REPEATABLE READ

   SNAPSHOT

   SERIALIZABLE

   If the TransactionIsolationLevel tag is not specified in the file the default value of READ COMMITTED will be used.
   
   Ignoring any comments (indicated with <!->), the final file should look like this:

   <EngineOptions version="3" type="EngineOptions">
   	<TransactionIsolationLevel>REPEATABLE READ</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.