BUG: Sort Objects by Create Date Shows Incorrect Order (230375)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug KB230375 |
|---|
|