A personal repository of technical notes. - CSC

SQL Server Management Studio Default My Projects Location

Problem
Need to change default location of My Projects folder in SSMS

Solution for SSMS 2008
Had to add a new registry entry "VisualStudioProjectsLocation" of type "Expandable String Value" (REG_EXPAND_SZ) at
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell

Solution That Worked for SSMS 2005
Modify registry entry "VisualStudioProjectsLocation" at
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell

References for Solution That Worked for SSMS 2005
"How to change the default ‘My Projects’ location in SQL Server Management Studio «." Pepper's Perspective. Web. 15 Sept. 2009. <http://p3john.wordpress.com/2009/08/11/how-to-change-the-default-my-projects-location-in-sql-server-management-studio/>.


Solution That Did Not Work for SSMS 2005
This solution did not work for me. After saving vssettings file, SSMS regenerated the settings file with the old values on the next start after displaying message "Microsoft SQL Server Management Studio is configuring the environment for first time use. This might take a few minutes."

Manually modify SSMS *.vssettings XML file at location:
\My Documents\SQL Server Management Studio\Settings\

See entry:
<PropertyValue name="ProjectsLocation">%vsspv_visualstudio_dir%\Projects</PropertyValue>
References for Solution That Did Not Work for SSMS 2005
"Changing the My Projects folder location (and other settings) in SSMS :." Visual Studio Hacks. Web. 15 Sept. 2009.
<http://visualstudiohacks.com/tips/options/changing-the-my-projects-folder-location-and-other-settings-in-ssms/>.

Updates
2011-07-05 Added SSMS 2008 references.

3 comments:

Anonymous said...

thanks!

VlSher said...

This is the best post I've found, but the solution still has a gap - when one saves a newly created query (in my SSMS 2008 setup I open it on startup) then he has to click "Projects" on the left, as save dialog opens in the standard ...\Documents\SQL Server Management Studio\Projects. Has anybody got a fix?

Anonymous said...

The same happens to me VlSher, using Management 2008.

Post a Comment