> John,
>
> You're right there isn't an equivalent option under Tools > Options
> for SQL Server Management Studio.
>
> If you have Visual Studio 2005 and SQL Server Management Studio
> installed you should, I think, have two .vssettings files. Do a Search
> for those and, I anticipate, you will see that the SQL Server
> Managment Studio file is at the location defined by the Registry key I
> mentioned earlier. At least that's how it looks to me.
>
> I am not aware of this being documented and I haven't had occasion to
> try it out ... so interpret at your own risk!
>
> I think the values for AutoSaveFile and DefaultSettingsDirectory at
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
> Server\90\Tools\Shell\Profile specify the directory locations that are
> of interest to you.
>
> It **looks likely to me** that that value is derived from the value of
> VisualStudioLocation at HKEY_CURRENT_USER\Software\Microsoft\Microsoft
> SQL Server\90\Tools\Shell.
>
> As I say I haven't tried this and it would be at your own risk but if
> I wanted to try moving the location of the settings file I would edit
> the value of VisualStudioLocation at the key mentioned in the
> preceding paragraph.
>
> You may want to see if any others offer any other suggestions. Or
> confirmation of the suggestion.
>
> Andrew Watt MVP
>
> On Thu, 20 Jul 2006 06:25:02 -0700, jp discussions.microsoft.com>
> wrote:
>

>>Thank you the response, Andrew. I probably should have shared what is
>>driving my question.
>>
>>SQL 2005 Mgt Studio appears to share an issue with Visual Studio on networks
>>with roaming profiles. That being everytime you log on to a machine and try
>>to open Mgt Studio, the program says it is "configuring itself for first time
>>use".
>>
>>The solution for Visual Studio is to place the settings file somewhere other
>>than the My Documents folder. This is configurable within Visual Studio
>>under Tools>Options and I don't see an equivalent place in SQL Mgt Studio.
>>
>>As far a I can see, the settings file you refered me to is only editable
>>within Management Studio and 1) the location of the file itself is probably
>>the issue and I could be wrong but it doesn't make sense to me that the
>>settings file would contain a path to find itself and 2) the registry key you
>>pointed me to
>>(%vsspv_visualstudio_dir%\Settings\CurrentSettings-2006-03-28-1.vssettings)
>>looks like it might be specifc to Visual Studio instead of SQL Mgt Studio and
>>besides that, I'm not smart enought to see how you could modify the drive
>>letter in that string to redirect this.
>>
>>I hope my problem is clearer now. Thanks again for your help.
>>
>>--
>>John Shahan
>>
>>
>>"Andrew Watt [MVP]" wrote:
>>

>>> John,
>>>
>>> I think the following may be what you want.
>>>
>>> Take a look in
>>> C:\Documents and Settings\UserName\My Documents\SQL Server Management
>>> Studio\Settings
>>> or equivalent.
>>>
>>> I think the .vssettings file there may be what you want.
>>>
>>> There is a Registry key in HKCU which, I believe, points to that
>>> location.
>>>
>>> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
>>> Server\90\Tools\Shell\Profile
>>>
>>> See AutoSaveFile.
>>>
>>> Andrew Watt MVP
>>>
>>> On Tue, 18 Jul 2006 15:48:01 -0700, jp discussions.microsoft.com>
>>> wrote:
>>>

>>>>I want to redirect the settings file for SQL Mgt Studio so that it is stored
>>>>on my local drive instead of the nework. I haven't been able to find the
>>>>string in either the registry or in the Tools>Options menu like it is in
>>>>Visual Studio.
>>>>
>>>>Thanks in advance for the pointer.
>>>>--
>>>>John Shahan

>