Changing SQL Server Management Studio "My Projects" path

Hi,

I want to change the default "My Projects" save location from "My Documents\SQL Server Management Studio\Projects" to somewhere else. I didn't see the My Projects path in the SQL Server Management Studio Options.

How can I change the path?

Thanks,

Mike

One way is to use Regedit, and search for 'SQL Server Management Studio\Projects'.

You will find the location for NewProjects, DefaultProjects, NewProjItems, DefaultProjItems -and a few other things you might like to know about.

As always, with editing the registry, use caution.

|||I have the same question/issue. I've looked for a registry entry like 'SQL Server Management Studio\Projects' but have not been able to locate anything that even comes close. Running under Windows Vista Enterprise. Can you give the full path to the registry key? TIA|||

On my computer, Windows Server 2003, I found it in two locations:

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

AND

HKEY_USERS\{My SID}\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell

The values to find and change are:

DefaultNewProjectLocation

MyDocumentsLocation

Both need to be 'Expandable String Value' data

Again, the RegEdit search was for: [SQL Server Management Studio\Projects]

(no square brackets)

|||For SQL Server Express the location within the registry is:

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

and the search item to use is:

"SQL Server Management Studio Express\Projects"

Changing SQL Server Management Studio "My Projects" path

Hi,

I want to change the default "My Projects" save location from "My Documents\SQL Server Management Studio\Projects" to somewhere else. I didn't see the My Projects path in the SQL Server Management Studio Options.

How can I change the path?

Thanks,

Mike

One way is to use Regedit, and search for 'SQL Server Management Studio\Projects'.

You will find the location for NewProjects, DefaultProjects, NewProjItems, DefaultProjItems -and a few other things you might like to know about.

As always, with editing the registry, use caution.

|||I have the same question/issue. I've looked for a registry entry like 'SQL Server Management Studio\Projects' but have not been able to locate anything that even comes close. Running under Windows Vista Enterprise. Can you give the full path to the registry key? TIA|||

On my computer, Windows Server 2003, I found it in two locations:

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

AND

HKEY_USERS\{My SID}\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell

The values to find and change are:

DefaultNewProjectLocation

MyDocumentsLocation

Both need to be 'Expandable String Value' data

Again, the RegEdit search was for: [SQL Server Management Studio\Projects]

(no square brackets)

Changing default folder for saving query text

When I save a query (not a query result) in SSMS, the default root folder is
My Documents\SQL Server Management Studio\Projects
Is there any way to change this default and make it persist beyond the current session?

Hello,

Yes it is possible for you to set the default folder to your prefered location. Open Microsoft SQL Server 2005 Management Studio.

From the Menu select Tools -> Options. Select Query Results noted and enter your prefered location where you want to save your queries in the "Default locations for saving query results" text box.

Thanks

|||Yes, I'm well aware that this setting is available for query results, but I'm asking about the query text itself - how do I change the default save path for the query text?