Monday, March 19, 2012

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"

No comments:

Post a Comment