Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Setup / November 2006

Tip: Looking for answers? Try searching our database.

How do you get "My Documents" onto the Open File dialog box?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
j_mcarthur@usa.net - 28 Nov 2006 18:08 GMT
"My Documents" does not appear on the left hand side of my Open File
dialog box.  Is there an easier way of getting it on there besides
hacking through my Registry keys?  If so, how?  If not, does anyone
happen to know which key it is in the Registry?  Thanks.

Joe
jebuskrust@gmail.com - 28 Nov 2006 19:10 GMT
It doesnt appear in mine. :( Oh noz its a sign that the world is gunna
end.

On Nov 28, 1:08 pm, j_mcart...@usa.net wrote:
> "My Documents" does not appear on the left hand side of my Open File
> dialog box.  Is there an easier way of getting it on there besides
> hacking through my Registry keys?  If so, how?  If not, does anyone
> happen to know which key it is in the Registry?  Thanks.
>
> Joe
j_mcarthur@usa.net - 28 Nov 2006 19:30 GMT
How wonderfully helpful you are (tic).

For everyone else ... it seems I may have a related issue, which may
indicate a more generic problem with my settings?  I know for a fact
that my open dialog box used to remember the last location from which I
successfully opened a file.  It no longer does so.  If anyone else has
experienced this weird bahavior and/or knows how to correct it, I'd
definitely appreciate hearing from you.

Joe

> It doesnt appear in mine. :( Oh noz its a sign that the world is gunna
> end.
[quoted text clipped - 6 lines]
> >
> > Joe
Arnie Rowland - 28 Nov 2006 20:20 GMT
What application are you using?

I have no clue if you are talking about Visual Notepad, or Outlook, or EM or
QA or SSMS, etc.

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

> "My Documents" does not appear on the left hand side of my Open File
> dialog box.  Is there an easier way of getting it on there besides
> hacking through my Registry keys?  If so, how?  If not, does anyone
> happen to know which key it is in the Registry?  Thanks.
>
> Joe
j_mcarthur@usa.net - 29 Nov 2006 00:07 GMT
SSMS.

> What application are you using?
>
> I have no clue if you are talking about Visual Notepad, or Outlook, or EM or
> QA or SSMS, etc.
Arnie Rowland - 29 Nov 2006 00:10 GMT
For me, in SSMS, [My Documents] displays right under [My Network Places]
toward the bottom of the list.

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

> SSMS.
>
[quoted text clipped - 3 lines]
>> or
>> QA or SSMS, etc.
j_mcarthur@usa.net - 29 Nov 2006 00:37 GMT
As for me, I'm only getting: [Desktop], [My Projects], and [My
Computer].  So how do I get [My Documents] into the list?

> For me, in SSMS, [My Documents] displays right under [My Network Places]
> toward the bottom of the list.
jebuskrust@gmail.com - 29 Nov 2006 14:49 GMT
Hey!!!
That's not very nice!

Ive always been helpful :)

To answer your question. I thought the situation was odd myself until I
realized it was missing from mine as well :( And I have no clue how to
resolve it and that's why I replied with what I said. Hey but you know
something? :) At least I replied with something, even if it wasn't what
you were expecting :(

> As for me, I'm only getting: [Desktop], [My Projects], and [My
> Computer].  So how do I get [My Documents] into the list?
>
> > For me, in SSMS, [My Documents] displays right under [My Network Places]
> > toward the bottom of the list.
Jay B - 29 Nov 2006 17:37 GMT
my documents is really under the "c:\documents and settings\username\my
documents"
you should be able to find what you are looking for there.

"my documents" is really a shortcut to the real documents location, and
changes with every user, and sqlserver can persist past user logins, and
therefore, it always needs a permanent folder for the databases it opens.

> "My Documents" does not appear on the left hand side of my Open File
> dialog box.  Is there an easier way of getting it on there besides
> hacking through my Registry keys?  If so, how?  If not, does anyone
> happen to know which key it is in the Registry?  Thanks.
>
> Joe
j_mcarthur@usa.net - 29 Nov 2006 19:08 GMT
Actually "My Documents" does not point to "c:\documents and
settings\username\my documents".  Rather, it points to a folder on one
of our network servers that is specifically assigned to me.

When you say that "I should be able to find what I'm looking for
there", what exactly do you mean?  I keep all of the .sql files that I
work on in a subfolder under my My Documents folder, specifically
because the server that it's on is backed up every night.  So whenever
I'm working in SQL Server Management Studio and want to open a .sql
file it would be nice to have My Documents as an option on the left
hand side (as it is in the Open dialog box of just about any other
Microsoft related program I've ever used).

Re: your last paragraph ... I'm not getting the point you are trying to
make here.  What does the fact that "My Documents" is a shortcut to a
real folder have to do with the persistence of any folder, or the SQL
Server DB?

> my documents is really under the "c:\documents and settings\username\my
> documents"
[quoted text clipped - 10 lines]
> >
> > Joe
Jay B - 29 Nov 2006 19:28 GMT
well, i didnt know you were talking about .sql files, my assumption was
databases.
in the last paragraph, if the user logs out, and then logs in as a
different user, then "my documents" now points to a different place.
i just thought that wouldnt be a good idea to point to files in a
dynamic location like that.

but to better answer your original question, i also notice that the "my
documents" folder is not on the left side either.  there are a lot of
cosmetic changes like that in the new sql2005 that i dont agree with
either.  i don;t know of any tweak to put it back on, but cant you just
hit the desktop button, then you will see my documents on the right
side, and then you can click from there.  also, the pull down combo box
also shows my documents.  so there are 2 ways to get to your documetns
rather than 3.  i hope this was helpful.

> Actually "My Documents" does not point to "c:\documents and
> settings\username\my documents".  Rather, it points to a folder on one
[quoted text clipped - 28 lines]
>>>
>>> Joe
j_mcarthur@usa.net - 30 Nov 2006 18:45 GMT
The Open dialog box in SSMS lets you open either a single file or a
project/solution.  Neither of these is a database so I'm not sure where
you got that idea.

I did a search through my registry and did not find anything that
looked related to what is on the open file dialog box so I'm inclined
to agree with you that there are no simple tweaks for adding something
to it.  Where do I find the "pull down combo box" that you speak of?

I think what was perturbing me the most when I started this thread was
the fact that my open file dialog box was not "remembering" the folder
from where I last opened a file.  The folder where I keep my working
.sql files is several levels below My Documents so it was a real pita
having to re-navigate there every time I wanted to open a file.  This
anomaly has somehow managed to correct itself after a restart so I'm
hoping I no longer have an issue.

Thanks for the help and suggestions.

Joe

> well, i didnt know you were talking about .sql files, my assumption was
> databases.
[quoted text clipped - 11 lines]
> also shows my documents.  so there are 2 ways to get to your documetns
> rather than 3.  i hope this was helpful.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.