SSMS closing after combining tabs

Marco Andres Guevara Bocanegra 21 Reputation points
2021-03-23T17:09:17.857+00:00

SSMS closes when I combine one tab with another, when these tabs are in separate windows (not the main window where I have the object explorer). I am using the following, if it helps:

SQL Server Management Studio 15.0.18369.0
SQL Server Management Objects (SMO) 16.100.46041.41
Microsoft Analysis Services Client Tools 15.0.19342.0
Microsoft Data Access Components (MDAC) 10.0.19041.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19042

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
Accepted answer
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-03-24T02:39:43.38+00:00

    Hi @Marco Andres Guevara Bocanegra ,

    Please follow these steps to mitigate the issue:

    1. Close all SQL Server Management Studio (SSMS) instances.
    2. Locate your SSMS application file (exe). This is commonly found in C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE.
    3. Open the file Ssms.exe.config in Notepad as Administrator.
    4. Locate the AppContextSwitchOverrides node and append these two properties to the value. ;Switch.System.Windows.Interop.MouseInput.OptOutOfMoveToChromedWindowFix=true; Switch.System.Windows.Interop.MouseInput.DoNotOptOutOfMoveToChromedWindowFix=true

    81307-ssms.png

    5.Save the config file and reopen SSMS.

    Please refer to Workaround to move tabs to get more information about SSMS crashed when you re-dock tab.

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viorel 112.1K Reputation points
    2021-03-23T19:42:39.7+00:00

    Check if your problem is like this one: https://learn.microsoft.com/en-us/answers/questions/281980/index.html. The problem was observed for Visual Studio too. Try installing the latest updates for Management Studio (using “Check for updates” from Tools menu) and Windows. But it is probably better to install the newest Management Studio (18.8).

    0 comments
  2. Erland Sommarskog 100.9K Reputation points MVP
    2021-03-23T22:37:31.78+00:00

    SSMS 18.8 is not going to help. Viorel suggested some threads, but this thread has the workarond (look for a post by Vinnie Amir):
    https://learn.microsoft.com/en-us/answers/questions/263738/ssms-188-crashes-when-re-docking-tabs.html

    0 comments