Alex Rivera | Logout

Change the default save location for SQL Management Studio 2008

Asked 2011-07-26T04:35:44.617
12

As the title states, how do I do this?

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

sql ssms sql-server-2008
Edit
Report

1 Answer

1

This seems to work for me after a lot of bungling -

  1. Edit registry settings as outlined in above posts (HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell) - change all the paths EXCEPT MyDocumentsLocation (this is what seems to cause the settings to get reset).

  2. Locate the .vssettings file from My Documents and copy to your folder + '/Settings' folder (e.g. c:\Dox\SQL Server Management Studio\Settings).

  3. Start SQL studio, quit and restart.

  4. Edit the .vssettings file (should be in your folder now rather than My Documents), and change the ProjectsLocation to the desired folder e.g. C:\Dox\SQL Server Management Studio\Projects

  5. Start SQL studio. Opening files should now work, but save will require clicking the 'My Projects' on the left of the save dialog.

answered 2012-01-31T13:52:20.470

Your Answer