question

MarcoAndresGuevaraBocanegra-2071 avatar image
0 Votes"
MarcoAndresGuevaraBocanegra-2071 asked CarrinWu-MSFT commented

SSMS closing after combining tabs

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-general
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MarcoAndresGuevaraBocanegra-2071, we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

Sorry I didn't get email notifications about responses, but I tried now with the proposed solution and it worked perfectly. Thanks a lot!

0 Votes 0 ·
CarrinWu-MSFT avatar image CarrinWu-MSFT MarcoAndresGuevaraBocanegra-2071 ·

No problem, have a nice day! :)

0 Votes 0 ·
CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT commented

Hi @MarcoAndresGuevaraBocanegra-2071,

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.





ssms.png (56.0 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

The answer from Carrin was a god send, this has been frustrating me for weeks now, like what's really good with QA on software products inside MS these days. I don't know how she figured this out but man she literally has saved my life in terms of work productivity getting this feature to work again especially when you have multiple screens of dev.

0 Votes 0 ·

Thank you for your comment! This workaround is from Microsft that will hope all the community members work with Microsft products smoothly.

0 Votes 0 ·
Viorel-1 avatar image
0 Votes"
Viorel-1 answered Viorel-1 edited


Check if your problem is like this one: https://docs.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).



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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://docs.microsoft.com/en-us/answers/questions/263738/ssms-188-crashes-when-re-docking-tabs.html

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.