SQL Server Managemet Studio folder

[katehol]

Hope someone can help me with this annoyance...

Every time I open MS SQL Server Management Studio it automatically creates a folder in My Documents. However, I have the same folder stored elsewhere, as I don't want it at this level - is there any way I can point it to this other location instead so I don't have these excess folders being created?

Thanks

 

[mrdenny]

I don't believe so.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[snitin78]

You may want to try the following. I am not sure if it will work or not (never tried and don't want to either ) but worth a shot!

In SSMS, go to Options --> Query Results.

There point "Default location for saving query results:" to the folder you want

Close SSMS, delete the My Documents folder and start SSMS again. See if it creates the folder again.

Let us all know the results

 

[katehol]

I'd already tried doing that actually, and it doesn't work

 

[RyanEK]

I believe the relevant registry values for these settings are stored in HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell

You could try updating the default values located under this key. Please use with caution though, I suggest you create a registry backup first.