Open a new query window. Write some SQL. Save the script, the Save File As dialog box opens - but always to the same default location in the Profiles directory. Is there any way to set my default file location? ...Like I used to do with apps from the 1980s?
Under Tools|Options a default location can be specified for query results. I need the same thing for new queries (the text editor). Tried changing locations in the Registry but SSMS just overwrote my changes. Any suggestions?
(I saw this unanswered question at http://www.eggheadcafe.com/software/aspnet/30098335/management-studio-default.aspx and I had same exact question so I just reposted it here)
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
.vssettingsXML file inMy Documents\SQL Server Management Studio\Settingsfolder. 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 theMy Projectsfolder, you are looking for this line:
<PropertyValue name="ProjectsLocation">%vsspv_user_documents%\My
Projects</PropertyValue>
The value inside is the location of the
My Projectsfolder. Simply change the value, and the next time you open SSMS theMy Projectsfolder will be mapped.