How to open multiple .sql files in only one SSMS instance

Question

How to open multiple .sql files in only one SSMS instance

Amir Hossein Hozouri 0

Hello everyone,

I have a problem on SQL Server Management Studio (SSMS) version 20.2.30.0.

Since i upgraded my SSMS, when i wanna open my sql file, instead of open it on one window and new tab on there, it'll open in multiple window.

It should be mentioned that i changed registry and enabled all check boxes on tabs and window on option environment.

Thanks for your support.

CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2024-09-25T01:39:18.3833333+00:00

Hi @Amir Hossein Hozouri ,

We have not received a response from you. Did the reply could help you? If the response 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.
Viorel 122.5K Reputation points

2024-09-27T14:00:13.6+00:00

Maybe the Registry is incorrect after the unnecessary changes.

1 answer

Your answer

CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2024-09-25T01:39:18.3833333+00:00

Hi @Amir Hossein Hozouri ,

We have not received a response from you. Did the reply could help you? If the response 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.
Viorel 122.5K Reputation points

2024-09-27T14:00:13.6+00:00

Maybe the Registry is incorrect after the unnecessary changes.

Answer 1

CathyJi-MSFT 22,396 Microsoft External Staff

Hi @Amir Hossein Hozouri

Please use the "Open With" option in Windows to resolve this issue. Open Folder options: right click on the file -> select "properties" -> you should see the option "Open with" where you have a button to change the related application which open the file. Click on the button "change" -> select a different application like SSMS2.0 -> approve and close everything.

9-24-3

By the way, you can open the .sql file as below screenshot. The multiple .sql files are opened in one SSMS.

9-24-4

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Gabriel de Figueiredo 0 Reputation points

2024-09-27T13:21:37.7833333+00:00

That doesn't resolve the issue. I notice that the option "Run in separate memory space" in Advanced Properties for the shortcut to SSMS has been checked/ticked, but grayed out. Any reason why this option has been automatically specified?
Gabriel de Figueiredo 0 Reputation points

2024-09-27T13:39:02.3066667+00:00

Advanced properties for the shortcut to SSMS has a "Run in separate memory space" tick-box ticked, but grayed out. Why?
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-09-27T20:54:35.4933333+00:00

Advanced properties for the shortcut to SSMS has a "Run in separate memory space" tick-box ticked, but grayed out. Why?

Don't know, but this seems to apply to all shortcuts that I have, not only SSMS.

Share via

How to open multiple .sql files in only one SSMS instance

1 answer

Your answer