Re: MS SQL Server Management Studio - Import and Export Settings

I have already set the values in that registry key to reference my
desired project location. And the result was successful. But my
question is regarding the behaviour when Management Studio is
started. It creates the SQL Server Management Studio\Projects folder
in My Documents. I don't see any value in the registry key that
references this path. There are no files written to this folder, but
if I delete it is re-created when I open Management Studio. If you
have any other ideas let me know, thanks.


On Jun 7, 5:09 am, v-ada...@xxxxxxxxxxxxxxxxxxxx (Adams Qu [MSFT])
wrote:
Dear Jeffery,

Thank you for posting here.

I understand that you would like to know where the variable
"%vsspv_visualstudio_dir%" and other SQL Server variables are set. Thank
you for your inquiry.

As far as I know, these variables are defined in the hard code and we
cannot reset or change these variables by design. Regarding the behavior
you have experienced, I would like to explain that this is a normal
behavior and it is done by the information in the following registry entry:

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

Under this registry key, we can find many subkeys (I.E:
"DefaultOpenSolution location") are set to "%USERPROFILE%\My Documents\SQL
Server Management Studio\Projects". If such location does not exist, SQL
Server will re-create this directory when we launch the SQL Server
Management Studio.

For more information, if we manually remove the whole "Shell" registry key,
SQL Server will also rebuild all these keys automatically after we launch
the SQL Server Management Studio.

Have a nice day!

Best regards,

Adams Qu, MCSE 2000, MCDBA
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! -www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: Jeff <JeffreyGarn...@xxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.setup
| Subject: Re: MS SQL Server Management Studio - Import and Export Settings
| Date: Wed, 06 Jun 2007 13:40:32 -0000
| Organization:http://groups.google.com
| Lines: 13
| Message-ID: <1181137232.478345.299...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
| References: <11E06121-151E-4E48-A7D8-2F0E5D42C...@xxxxxxxxxxxxx>
| <rcIrOYApHHA.1...@xxxxxxxxxxxxxxxxxxxxxx>
| <1F358D68-9073-4640-868C-B29720BE6...@xxxxxxxxxxxxx>
| NNTP-Posting-Host: 204.15.160.254
| Mime-Version: 1.0
| Content-Type: text/plain; charset="us-ascii"
| X-Trace: posting.google.com 1181137232 16161 127.0.0.1 (6 Jun 2007
13:40:32 GMT)
| X-Complaints-To: groups-ab...@xxxxxxxxxx
| NNTP-Posting-Date: Wed, 6 Jun 2007 13:40:32 +0000 (UTC)
| In-Reply-To: <1F358D68-9073-4640-868C-B29720BE6...@xxxxxxxxxxxxx>
| User-Agent: G2/1.0
| X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET
CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30),gzip(gfe),gzip(gfe)
| Complaints-To: groups-ab...@xxxxxxxxxx
| Injection-Info: p47g2000hsd.googlegroups.com; posting-host=204.15.160..254;
| posting-account=oMnCxw0AAAAZKA4tpu_NxnEWb0sp4z6V
| Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!news-out­.
cwix.com!newsfeed.cwix.com!newscon02.news.prodigy.net!prodigy.net!border1..n­n
tp.dca.giganews.com!nntp.giganews.com!postnews.google.com!p47g2000hsd.googl­e
groups.com!not-for-mail
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.setup:1996
| X-Tomcat-NG: microsoft.public.sqlserver.setup
|
| Do you know where "%vsspv_visualstudio_dir% and other sql server
| management studio variables are set? I've successfully relocated my
| settings file follwoing the instructions above, but everytime I open
| management studio a folder named Sql Server Management Studio with a
| sub-folder named Projects is created in My Documents. It looks like
| this may result from a section in the currentsettings file:
|
| <PropertyValue name="ProjectsLocation">%vsspv_user_documents%\SQL
| Server Management Studio\Projects</PropertyValue>
|
| Regardless, if you know where vsspv_user_documents is defined could
| you let me know, thanks
|
|


.

Relevant Pages

  • Re: MS SQL Server Management Studio - Import and Export Settings
    ... Server will re-create this directory when we launch the SQL Server ... For more information, if we manually remove the whole "Shell" registry key, ... the SQL Server Management Studio. ...
    (microsoft.public.sqlserver.setup)
  • Re: Fulltext failure on a 2 node cluster
    ... To remove the failed full-text search resource from your clustered instance ... Start Cluster Administrator on the node that has the failed full-text ... Delete the registry keys that are related to the instance of SQL Server ... locate and then click the following registry key: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Fulltext failure on a 2 node cluster
    ... It was "one" registry key that I was refering to. ... To remove the failed full-text search resource from your clustered ... Start Cluster Administrator on the node that has the failed full-text ... as your instance of SQL Server. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Fulltext failure on a 2 node cluster
    ... To remove the failed full-text search resource from your clustered ... Start Cluster Administrator on the node that has the failed full-text ... Delete the registry keys that are related to the instance of SQL Server ... locate and then click the following registry key: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Fulltext failure on a 2 node cluster
    ... To remove the failed full-text search resource from your clustered instance ... Start Cluster Administrator on the node that has the failed full-text ... Delete the registry keys that are related to the instance of SQL Server ... locate and then click the following registry key: ...
    (microsoft.public.sqlserver.clustering)
Loading