Microsoft KB Archive/230375

= BUG: Sort Objects by Create Date Shows Incorrect Order =

Article ID: 230375

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q230375



BUG #: 55274 (SQLBUG_70)



SYMPTOMS
When attempting to sort objects (tables, views, stored procedures, and so forth) by using the create date column in SQL Enterprise Manager, the columns are not ordered in the correct chronological sequence.



CAUSE
The objects are sorted as if the create date column is text instead of a date field. Thus, an object with a create date value of 4/12/99 appears prior to an object with a create date of 4/8/99.



WORKAROUND
You can run the following query from query analyzer to get the same information displayed in SQL Enterprise Manager for all user and system tables ordered by create date: select [a].[Name], [b].[name] as 'Owner', case a.type when 'S' then 'System' When 'U' then 'User' end as 'Type', crdate as 'Create Date' from sysobjects a, sysusers b where a.uid = b.uid AND (type = 'U' or type = 'S') order by crdate



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Keywords: kbbug kbpending KB230375

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.