SSMS crash after one sql query window pull to another sql query window

Олег Петровский 21 Reputation points
2021-02-22T12:57:09.507+00:00

SSMS crash after one sql query window drug to another sql query window
steps to reproduce
1)Open Microsoft SQL Server Management Studio 18
2)Connect to DB
3)Open two sql query
4)drag second window on first window
5)Observe ssms crash close

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.19041
![70589-image.png]1

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,765 questions
0 comments No comments
{count} votes

Accepted answer
  1. CarrinWu-MSFT 6,856 Reputation points
    2021-02-23T01:47:00.42+00:00

    Hi @Олег Петровский ,

    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
      
      70808-1.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. And there has one case is similar with you.

    And we already tested the workaround in our side, it works well. If the workaround still not work, please check which version of Windows and SSMS you are using? If you are using Windows 10 (version 1809) or Windows Server (version 2019), please apply the fix in your environment to rosolve your issue. Please refer to February 16, 2021-KB4601558 Cumulative Update Preview for .NET Framework 3.5 and 4.7.2 for Windows 10, version 1809 and Windows Server, version 2019 to get more information.

    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.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful