Hi Folks,

I'm sure this has been answered before but all my searches for this problem don't find what I need. It's a quirk but driving me nuts.

If I have sql management studio open and I view a sql file from Vault, or double-click it in explorer, it always opens a new instance of mgmt studio. I open 5 sql files, 5 instances of mgmt studio.

How do I tell my system to reuse mgmt studio to open sql files if it's open?

Thanks in Advance,

-David

What version of SQL Server Management Studio do you have?

9.00.1399 = RTM
9.00.2047 = SP1
9.00.3042 = SP2

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Having the same issue. 9.00.3042. Thanks.

Hello,

I have done a little try:
i have searched a 1st file with the extension .txt , double-click onit => the file is open in a 1st notepad window
i have searched a 2nd file with the extension .txt, double-click on it => the file is open in a 2nd notepad window
it is because the extension .txt is associated with the program notepad.exe
if you do the same thing with 2 files having the extension .sql, you will obtain 2 instances of ssms
it is because during the install of Sql Server, .sql is open thru Sql Server Management Studio on default

2 solutions :
- you don't double-click on a .sql file
- you suppress the association .sql <=>SSMS
for that :
click on start
click on config panel
click on folders oprions
click on the tab files types ( the 3rd one )
find the extension SQL
click on advanced
and unckech the checkbox : open with this program ( the hightlighted one )
and click on OK

I advice you to choose the 1st solution ( i am not sure that at the 1st update of Sql Server , the association will not be created )

You are facing to the way of the double-click is treated by Windows

Have a nice day

---

Please remember to click 'Mark as Answer' on the post that helped you. Unmark if it provides no help

You could drag and drop the file into studio manager also

---

John K. Knowledgy Solutions http://knowledgy.org/