SQL Source Control 3

Enabling multiple SSMS windows

This option can now be easily changed on the Setup tab in SQL Source Control 3.8.11. This update is free for SQL Source Control 3 users.

If you don't want to update, follow the instructions below.

By default, SQL Source Control is disabled for use in multiple SSMS windows. You can change this by editing a config file.

Accessing large databases in multiple SSMS windows uses a large amount of memory. If you need to, you can disable multiple SSMS windows by undoing the changes described on this page.

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

  4. Inside the <EngineOptions> tags, add:

    <AllowMultipleSsms>True</AllowMultipleSsms>

    The file is case sensitive. Don't change the capitalization of the text.

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

    <EngineOptions version="3" type="EngineOptions">
    	<AllowMultipleSsms>True</AllowMultipleSsms>
    </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 and close the file.

SQL Source Control is now enabled for multiple SSMS windows.


Didn't find what you were looking for?