Re: MS SQL Server Management Studio - Import and Export Settings
- From: v-adamqu@xxxxxxxxxxxxxxxxxxxx (Adams Qu [MSFT])
- Date: Thu, 07 Jun 2007 09:09:01 GMT
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 <JeffreyGarnett@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.299640@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
| References: <11E06121-151E-4E48-A7D8-2F0E5D42C53B@xxxxxxxxxxxxx>
| <rcIrOYApHHA.1144@xxxxxxxxxxxxxxxxxxxxxx>
| <1F358D68-9073-4640-868C-B29720BE652D@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-abuse@xxxxxxxxxx
| NNTP-Posting-Date: Wed, 6 Jun 2007 13:40:32 +0000 (UTC)
| In-Reply-To: <1F358D68-9073-4640-868C-B29720BE652D@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-abuse@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.nn
tp.dca.giganews.com!nntp.giganews.com!postnews.google.com!p47g2000hsd.google
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
|
|
.
- Follow-Ups:
- References:
- Prev by Date: Re: SQL Server 2005 Express SP2 Install Error
- Next by Date: RE: MS SQL Server Management Studio - Import and Export Settings
- Previous by thread: Re: MS SQL Server Management Studio - Import and Export Settings
- Next by thread: Re: MS SQL Server Management Studio - Import and Export Settings
- Index(es):
Relevant Pages
|
