Change the default save location for SQL Management Studio 2008 [duplicate]

Question

As the title states, how do I do this?

I want to hit save, and have SSMS automatically direct me to a network folder..

Answer 1

This is 3 years old now, but an answer for SSMS 2012 and 2014 would be helpful, so I thought I'd add an update. Step one differs between the versions, and then the rest is the same:

SSMS 2012

1. Locate C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Extensions\Application

SSMS 2014

1. Locate C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions\Application

Both (continued)

2. Open ssms.application.pkgdef with text editor(e.g. Notepad)
3. Change the value of DefaultProjectsLocation
4. "DefaultProjectsLocation"="$MyDocuments$\SQL Server Management Studio"
5. Save the file

Thanks to this source: http://www.networksteve.com/forum/topic.php/How_to_change_the_default_query_save_location_in_SSMS/?TopicId=41425&Posts=0

Answer 2

The correct location for 2k8 in the registry is HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell.