Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2004
    Posts
    30

    Unanswered: Open Query File dialog box

    Hi,
    SQL2K+SP4
    When I load up Query Analyzer and click File -> Open to open up a query
    file, the open file dialog is always sorted by - i don't know
    alphabetically.
    How can I set the default to open up with files ordered alphabetically?

    Thanks
    Helena

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Query Analyzer uses the default directory order for the system, which is set from a registry entry somewhere in the bowels of Windows itself. The default order can be changed for all of the applications on a machine, but I don't remember how.

    -PatP

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    in the open file dialog, you can view by "details" and then sort by name, size, type, or modified date.

  4. #4
    Join Date
    Sep 2004
    Posts
    30
    Pat, thanks for replay

    "Query Analyzer uses the default directory order for the system"

    The files in Explorer / Outlook Insert File dialog box are in alphabetic order.
    Its only in QA the order is wrong.

    Thanks,
    Helena

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Jezemines answer is the one to go with. There's no point fussing over this imo!
    George
    Home | Blog

  6. #6
    Join Date
    Sep 2004
    Posts
    30
    I know to order the files in the box but I'm handling big number of scripts and I each time I want to open file I need to sort it first - its annoying

    Helena

  7. #7
    Join Date
    Sep 2004
    Posts
    30
    Just in case somebody has the same problem, here is the solution:

    http://support.microsoft.com/kb/229070

    Thanks
    Helena

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You've GOT to be kidding
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I missed the part about her using Windows 98, although I remember the problem from back then too. This became a registry fix starting with Windows 2000, but I don't remember the registry key or the values anymore because I haven't needed it for years.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •