How to Remove "SQL Server Management Studio" from My Docs?

27 Jun 2006 1:23 PM

JonOfAllTrades

Good morning. This is not important, but it's been irritating me, maybe
someone here knows the answer offhand?
Every time I start SQL Server Management Studio, it creates a directory in
my documents folder. This is "my" documents folder, organized with care. I
don't appreciate the clutter. I found a setting to move SSMS' settings file
and so forth, but it still creates an empty "~\SQL Server Management
Studio\Projects" folder every time. I've searched SSMS options and the
registry without success.
Does anyone know how to move this directory? Thanks!

28 Jun 2006 9:49 AM

Andrew Watt [MVP]

On Tue, 27 Jun 2006 06:23:02 -0700, JonOfAllTrades
<JonOfAllTra***@discussions.microsoft.com> wrote:

>Good morning. This is not important, but it's been irritating me, maybe
>someone here knows the answer offhand?
>Every time I start SQL Server Management Studio, it creates a directory in
>my documents folder. This is "my" documents folder, organized with care. I
>don't appreciate the clutter. I found a setting to move SSMS' settings file
>and so forth, but it still creates an empty "~\SQL Server Management
>Studio\Projects" folder every time. I've searched SSMS options and the
>registry without success.
>Does anyone know how to move this directory? Thanks!

Jon,

I'm not sure how much of your problem this might solve but try
re-setting Query Results > General > Default location for query
results.

In the registry, if you use Windows PowerShell, use this command to
display relevant values:

PS C:\Documents and Settings\Andrew Watt> get-itemproperty
"hkcu:\Software\Micro
soft\Microsoft SQL Server\90\Tools\Shell" -Name *

If you don't use PowerShell navigate to the comparable location using
Regedit.

You will see several relevant properties.

Andrew Watt MVP

18 Jul 2006 2:39 PM

JonOfAllTrades

Show quote

"Andrew Watt [MVP]" wrote:
> Jon,
>
> I'm not sure how much of your problem this might solve but try
> re-setting Query Results > General > Default location for query
> results.
>
> In the registry, if you use Windows PowerShell, use this command to
> display relevant values:
>
> PS C:\Documents and Settings\Andrew Watt> get-itemproperty
> "hkcu:\Software\Micro
> soft\Microsoft SQL Server\90\Tools\Shell" -Name *
>
> If you don't use PowerShell navigate to the comparable location using
> Regedit.
>
> You will see several relevant properties.

I appreciate the post, Mr Watt.
No, that didn't do it either. I'm guessing the setting I need to change is
something along the lines of "Default location for new SQL projects," but if
it's user-editable, I don't know where.

It used to be that one's C: drive got cluttered up with crap. Then the
Program Files directory. Now it's My Documents, what with Microsoft creating
My Videos and Adobe creating My eBooks. When will they learn to respect
their customers and stop tracking mud into the house?</rant>

Thanks for the ideas, though!