When I double-click .sql file it does not open in SSMS

Question

When I double-click .sql file it does not open in SSMS

mkovas

SSC Veteran

Points: 237
More actions
October 27, 2010 at 2:50 pm

#228556

When I click on a .sql file, Management Studio opens, but the .sql does not open and display in the session. I have made sure the SSMS is associated to .sql files (utilizing the the open with option and setting SSMS as default). Does anyone know how to fix this? I am running Windows 7 and SQL Server 2008 R2.

Viewing 5 posts - 1 through 4 (of 4 total)

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

jerry-621596 SSCertifiable Points: 6096 More actions · Answer 1

Right-click the file. Click Open With. Click on SSMS (If SSMS is not one of the Recommended Programs, click Other Programs and click SSMS). Make sure the Always use the selected program to open this kind of file checkbox is checked. Click OK.

This will reassign the file extension to SSMS and should open SSMS for all sql files in the future.

mkovas SSC Veteran Points: 237 More actions · Answer 2

This is quirky. The always use was selected. However, I actually unselected and clicked ok. Now it works every time for me. However, the next time I went to check to see if the box was still unselected...it was checked again. It still works.

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 3

what you are trying to do from it?

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]

mkovas SSC Veteran Points: 237 More actions · Answer 4

I just am trying to open a .sql script to run it in SSMS by double-clicking on the file. The steps I mentioned seemed to work.