Management Studio default file save location

Question

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)

Answer 1

Hi,

As a workaround, you could create new Project of type SQLServerScripts at the location you wish to store the scripts.

Then in the solution explorer just right click the queries folder to create a new script at the location you have specified.

Make sense?

Fore more detailed about Projects and solutions in SQL Server see:

http://msdn.microsoft.com/en-us/library/ms173803.aspx

Cheers,

Answer 2

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

-Edoode

Answer 3

the registry changes did not work for me. i just put a shortcut to the network folder I wanted to use in the Mgnt Studio default save path.