File list display

rdalton · February 15, 2006 6:41PM

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

petey · February 15, 2006 10:34PM

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?

rdalton · February 16, 2006 1:26PM

The results are not sorted using this query.

rdalton · February 16, 2006 1:28PM

When I look at the extended store proc in master, the path listed is xpstar.dll.

petey · February 16, 2006 1:32PM

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?

rdalton · February 16, 2006 1:41PM

yes, they are sorted.

petey · February 16, 2006 1:45PM

Thanks for checking that. We'll mark it down as a bug in SQL Backup.

File list display

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk