When I view directories or files, they are not in alphabetical order. I can't find any way to make them order differently.

I'm on ver 4.1
rdalton
0

Comments

6 comments

  • petey
    Are you referring to the directory browsers? They are drawn using the results from xp_dirtree e.g.

    EXECUTE master.dbo.xp_dirtree N'C:\', 1, 1

    Can you run the query in Query Analyzer and compare if the results are sorted there?
    petey
    0
  • rdalton
    The results are not sorted using this query.
    rdalton
    0
  • rdalton
    When I look at the extended store proc in master, the path listed is xpstar.dll.
    rdalton
    0
  • petey
    If you run SQL Server Enterprise Manager, and choose to restore a database using the 'From device' option, are the entries sorted in the Backup Device Location dialog?
    petey
    0
  • rdalton
    yes, they are sorted.
    rdalton
    0
  • petey
    Thanks for checking that. We'll mark it down as a bug in SQL Backup.
    petey
    0

Add comment

Please sign in to leave a comment.