How can we help you today? How can we help you today?

SQL Source Control and SSMS 21 issues

SSMS 21.2.5 and SQL Source Control 8

  1. SQL Source Control does not auto-start when SSMS starts. The Object Explorer context menu options don't appear, and none of the features seem to work until you click the SQL Source Control button in the toolbar. Then the Object Explorer context menu shows the Source Control options after you refresh it. I have to do this every time I open SSMS 21.
  2. In the Object Explorer, the object icons do not show the Source Control state (under Source Control, Changes Detected, etc) of the object anymore, like they did in SSMS 20. They show only the default SSMS icons.
Bryan Williams
0

Comments

1 comment

Sort by
  • Christian Perez
    Official comment

    Hi Bryan,
     
    Thanks for reaching out to Redgate Support regarding your Source Control issues. I was able to discuss this a bit further with the developers and they have concluded that this does appear to be the newly expected behavior from Source Control in SSMS 21. While the behavior you were seeing was indeed not nominal when comparing to older versions of Source Control, with SSMS 21, the initial loading behavior has changed. As a result, the SOC page does not auto load when SSMS 21 starts. This affects the initialization of certain events responsible for updating icons. Now (SSMSv21 onwards), these events get triggered whenever the SOC page is opened manually or the SOC button is clicked.
     
    Workaround options for you include the following. (Either of these steps will trigger the event and then the connected database will be identified as expected)
     
     

    • In SSMS 21, connect to DB server then open(Click on) SOC tab and Refresh the DB server. 
    • In SSMS 21, connect to DB server then open(Click on) SOC tab, Disconnect, and Reconnect the DB server.
      • Cancel the connection dialog when SSMS 21 opens, open the SOC page first, and then connect to the desired DB server.

     
    Let me know if you have any follow up questions or concerns.

    Christian Perez

Add comment

Please sign in to leave a comment.