change save settings directory on SSMS 2005

when i exit sql server management studio i get the following error:

The automatically saved settings file '\\SERVER\DATA\Sql Server Management Studio\Settings\CurrentSettings-2006-09-21.vssettings' is not available for write. You can change this file on the 'Import and Export Settings' Tools Options page.

i'm guessing this might be because of the corporate policy of pointing everyone's "My Documents" at a read-only folder.

i'd like to follow the advice on the dialog but unfortunately my Tools, Options dialog does not have an 'Import and Export Settings' page.

any ideas?

This problem relates to SSMS being an offshoot of the Visual Studio Shell. I would raise a bug in Connect http://connect.microsoft.com/sqlserver|||

You could try changing the registry I found this key that might be worth looking at

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell

|||

Probably the folder in which the vssettings file is present is a read-only location and that's why it's not allowing you to over-write it.

But you can very well re-direct your My Documents folder to any location(for which you have write access) and save the settings file will be saved when you close the SSMS.

For redirecting the My Documents folder, right click on it and select Properties and specify the new path in the Target folder location.

Hope that Helps.

Regards,

Rajesh

|||bug raised as https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=208955

Change owner of a DTS package?

I saved a dts package as a structured file from one SQL
server, then imported to another SQL server. Now, how can I
change the owner of that new package from me to dbo?
Thanks
--
E-mail correspondence to and from this address may be
subject to the
North Carolina Public Records Law and may be disclosed to
third parties.If I understood your question correctly, dts owner is
different than database user. You can specify dts owner
password who can modify the package, and a user password
who can execute it.
To change these passwords you have to save it again with
another name, after opening the dts package in dts
designer, click on Package->Save As, there you can enter
the new passwords.
hth.
>--Original Message--
>I saved a dts package as a structured file from one SQL
>server, then imported to another SQL server. Now, how
can I
>change the owner of that new package from me to dbo?
>Thanks
>
>--
>E-mail correspondence to and from this address may be
>subject to the
>North Carolina Public Records Law and may be disclosed to
>third parties.
>
>.
>|||Thanks, but maybe if I explain more fully you'll be able to
help me.
Joe developer created a dts package on 'oldserver'. The
package was owned by domain\joe. We needed to move the
database that Joe was working in to another server. I did a
backup from 'oldserver' and then restored the database to
'newserver'. Of course Joe's dts packages were not moved by
the backup/restore. I opened his dts packages on 'oldserver'
and did a "save as" with location = SQL Server and the Server=newserver. This moved the packages from oldserver to
newserver. The packages were owned by domain\tom on the
newserver. I'd like to change the package owner from
domain\tom to dbo or even to domain\joe would be ok. Surely
there must be some way to simply change the owner of a dts
package!?
Since then, I've just had Joe to the 'save as' to the new
server. That has solved the immediate problem. I'd still
like to know how to change the package owner.
Thanks
Tom
brian wrote:
> If I understood your question correctly, dts owner is
> different than database user. You can specify dts owner
> password who can modify the package, and a user password
> who can execute it.
> To change these passwords you have to save it again with
> another name, after opening the dts package in dts
> designer, click on Package->Save As, there you can enter
> the new passwords.
> hth.
> >--Original Message--
> >I saved a dts package as a structured file from one SQL
> >server, then imported to another SQL server. Now, how
> can I
> >change the owner of that new package from me to dbo?
> >
> >Thanks
> >
> >
> >--
> >E-mail correspondence to and from this address may be
> >subject to the
> >North Carolina Public Records Law and may be disclosed to
> >third parties.
> >
> >
> >.
> >
--
E-mail correspondence to and from this address may be subject
to the
North Carolina Public Records Law and may be disclosed to
third parties.|||In most cases, the package owner doesn't really matter and
can be ignored. You can find information on the subject in
the Package Ownership Issues article on sqldts.com:
http://www.sqldts.com/default.aspx?212
-Sue
On Wed, 08 Oct 2003 15:04:20 -0400, Tom Williams
<Tom.Williams@.ncmail.net> wrote:
>Thanks, but maybe if I explain more fully you'll be able to
>help me.
>Joe developer created a dts package on 'oldserver'. The
>package was owned by domain\joe. We needed to move the
>database that Joe was working in to another server. I did a
>backup from 'oldserver' and then restored the database to
>'newserver'. Of course Joe's dts packages were not moved by
>the backup/restore. I opened his dts packages on 'oldserver'
>and did a "save as" with location = SQL Server and the Server=>newserver. This moved the packages from oldserver to
>newserver. The packages were owned by domain\tom on the
>newserver. I'd like to change the package owner from
>domain\tom to dbo or even to domain\joe would be ok. Surely
>there must be some way to simply change the owner of a dts
>package!?
>Since then, I've just had Joe to the 'save as' to the new
>server. That has solved the immediate problem. I'd still
>like to know how to change the package owner.
>Thanks
>Tom
>
>brian wrote:
>> If I understood your question correctly, dts owner is
>> different than database user. You can specify dts owner
>> password who can modify the package, and a user password
>> who can execute it.
>> To change these passwords you have to save it again with
>> another name, after opening the dts package in dts
>> designer, click on Package->Save As, there you can enter
>> the new passwords.
>> hth.
>> >--Original Message--
>> >I saved a dts package as a structured file from one SQL
>> >server, then imported to another SQL server. Now, how
>> can I
>> >change the owner of that new package from me to dbo?
>> >
>> >Thanks
>> >
>> >
>> >--
>> >E-mail correspondence to and from this address may be
>> >subject to the
>> >North Carolina Public Records Law and may be disclosed to
>> >third parties.
>> >
>> >
>> >.
>> >