Is there any easy way of changing the SQL Server Management Studio default 'Project' folder? I found one registry hack on the internet, but I'd rather not bother with that.
I'm using SQL Server 2005 Express.
+4
A:
It doesn't look like it. There is no way of doing it from the options in management studio. You need to edit the paths stored in the registry at:
HKCU\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM
adrianbanks
2009-06-08 00:01:33
I agree with you +1
ichiban
2009-06-08 00:25:50
How annoying. It seems like an obvious thing to have an editable option for. I really don't want to be messing with the registry on a client's computer. Thanks to both of you - if nobody's come up with a better solution by tomorrow, I guess I'll accept this one.
dsteele
2009-06-08 03:24:45
+1
A:
According to this article you can do it by changing an config file as well.
LeoPasta
2009-06-08 16:09:25
I found the setting in the config file, and when I change the folder, SSME shows a 'configuring....' warning message when it loads. But it still doesn't change the default folder. Strange.
dsteele
2009-06-08 19:01:40
+1
A:
Registry Location on my machine:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell
I modified the DefaultFileOpenLocation key to change where my open file dialogue points to.
Jared
2010-10-04 18:52:11