How to change default query file directory in SSMS 2008R2.

Question

How to change default query file directory in SSMS 2008R2.

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

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

Bill Hansen Ten Centuries Points: 1201 More actions · Answer 1

This article details how you can change the default directory: http://visualstudiohacks.com/options/changing-the-my-projects-folder-location-and-other-settings-in-ssms/

hmbtx SSCarpal Tunnel Points: 4664 More actions · Answer 2

Thank you for your reply.

This appears to be exactly what I was looking for except that I cannot get it to work.

I changed <PropertyValue name="ProjectsLocation">%vsspv_visualstudio_dir%\Projects</PropertyValue>

to

<PropertyValue name="ProjectsLocation">\\server01\c$\d-drive\jcc_membership\howard\member\sql_queries</PropertyValue>

but it did not seem to change anything. When I click on file > open > file in SSMS the directory has not changed from the default.

Can you see a problem with my change? I know the path is valid since I cut it and pasted it into the start > run box and it brought up the directory.

Any help would be apprecated.

Howard

Bill Hansen Ten Centuries Points: 1201 More actions · Answer 3

I just tried it on my home machine and work machine with no luck.

I found another article that recommended adding a VisualStudioProjectsLocation entry to the Registry under HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Shell and I tried that as well and it didn’t work either. I changed the VisualStudioProjectsLocation key to match the ProjectsLocation attribute in the configuration file and that didn’t work either.

The default location has to be stored somewhere and it’s either in a config file or the registry but everything I’ve seen so far has not worked.

hmbtx SSCarpal Tunnel Points: 4664 More actions · Answer 4

Problem solved.

Below is a link that lead me to the solution which is a registry change.

http://stackoverflow.com/questions/6825306/change-the-default-save-location-for-sql-management-studio-2008

The register key is DefaultFileOpenLocation.

I changed this registry key and it worked.

Thanks to all for your help in this matter.

Howard

JJR333 Default port Points: 1469 More actions · Answer 5

JJR333

Default port

Points: 1469

March 9, 2014 at 10:16 am

#1695379

Thank you. Worked for me. 🙂

Julian