Management Studio default file save location

I know this is an old question, but I found a link expaining how to do this properly, at least for SQL 2005. Think it will work for later versions as well.

Changing the my projects folder

The settings are stored in an .vssettings XML file in My Documents\SQL Server Management Studio\Settings folder. Make sure you close SSMS before making changes to this file: SSMS writes to it when you close the application and will overwrite any changes you make. To change the My Projects folder, you are looking for this line:

   <PropertyValue name="ProjectsLocation">%vsspv_user_documents%\My
   Projects</PropertyValue>

The value inside is the location of the My Projects folder. Simply change the value, and the next time you open SSMS the My Projects folder will be mapped.


A simple work around is to create a shortcut to your desired save location. Place the shortcut in the SSMS\Projects directory. When saving, select "All Files (.)" at the bottom, then double click your shortcut.

Not ideal, but a quick and simple work around.


This is 5 years old now, but it doesn't mention SSMS version, so I thought I'd add an update for SSMS 2012 and SSMS 2014. 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

SSMS 2016

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

SSMS 17

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

SSMS 18

  1. Locate C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions\Application

All (continued)

  1. Open ssms.application.pkgdef with text editor(e.g. Notepad)
  2. Change the value of DefaultProjectsLocation "DefaultProjectsLocation"="$MyDocuments$\SQL Server Management Studio"
  3. For query storage location (query itself, not results), edit this: "DefaultUserFilesFolderRoot"="SQL Server Management Studio"
  4. 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


Just to make sure, did you update the locations in the registry here:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\ProjectLocationEntries

Tags:

Sql Server

Ssms

Recent Posts