When a SQL file will not open in SSMS

Question

Post reply

When a SQL file will not open in SSMS

Viewing 13 posts - 16 through 27 (of 27 total)

You must be logged in to reply to this topic. Login to reply

Rich Mechaber SSChampion Points: 11130 More actions · Answer 1

Odd, I have no entries in SSMS Tools, Options, Text Editor, File Extension and .sql files open fine....

XP SP 3 on the workstation, with SQL 2005 Enterprise server.

Rich

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Nice Find.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

jkevin.moss Newbie Points: 8 More actions · Answer 3

Didn't work for me either. Windows 7, SSMS 2008R2

If I already have SSMS up and doubleclick on the file it opens, but when going from "scratch" it only opens SSMS.

haveSomeYuccaCake Grasshopper Points: 15 More actions · Answer 4

haveSomeYuccaCake

Grasshopper

Points: 15

April 27, 2011 at 2:08 pm

#1316885

BTW, my SSMS was run in Windows Server 2008 R2.

Matt Penner SSC Enthusiast Points: 127 More actions · Answer 5

Just for reference:

The reason why unassociating and reassociating the extension with Windows and SSMS didn't work is because this simply tells Windows what program to launch when a file with that extension is opened. In this case, because SSMS actually did open the association was working fine. It's what SSMS does with the file once it opens is the problem, which is purely an SSMS thing.

Unfortunately, looking at the replies, what is causing SSMS to behave improperly is inconsistent and so are the fixes. 🙁

AngryPets SSC Journeyman Points: 91 More actions · Answer 6

Wow. Fantastic find. I've complained about this forever.

What's amazing is that it happens on so many systems.

Thanks for the fix!

lyco_us SSC Rookie Points: 26 More actions · Answer 7

Thanks. This was actually my first Publication. Glad it helped. Hopefully I can figure out the elusive SSMS 2008 R2 that that has the same issue. A developer I work with just found that he had that issue today. This solution didn't work.

lyco_us SSC Rookie Points: 26 More actions · Answer 8

Very welcome. This was my first Publication. Hope to have more !

TerryS SSCommitted Points: 1756 More actions · Answer 9

Solution does not work for me either, Win 7 x64. Since Windows 2008 Server R2 is also x64, maybe the issue lies there.

LiveCoach SSC Rookie Points: 48 More actions · Answer 10

I am sorry that when i read this Article and just do it , it do failure ,my server is Windows2003 EE & SqlServer2005 EE sp2

vinurvk Valued Member Points: 62 More actions · Answer 11

Here is my problem..

Whenever I try to open .sql file it keeps opening a new SSMS window. But originally, the .sql file will open as a separate tab if already a SSMS window is kept open, else it will open a new window.

Is there a way to restore such configuration - when i already have a SSMS window open - and when i try to open .sql file from windows explore - this file should open as a new tab in the same existing SSMS window and should not open a new SSMS window.

Any help would help a lot..

martin 30621 Newbie Points: 1 More actions · Answer 12

martin 30621

Newbie

Points: 1

June 13, 2011 at 4:10 am

#1337657

Very helful,

Thanks

chuckh1958 Newbie Points: 2 More actions · Answer 13

Wow - 13.5 years later, SSMS 20 is still experiencing this bug. Thanks for your help!