September 16, 2008 at 10:35 am
I don't know what happened, but I came in today and the date format in the 'create date' column for any list of objects (tables, sps, views, etc.) has changed. The lists no longer sort correctly by create date. This has affected all databases on the server.
The "create date" value used to be formatted as "9/15/2008 2:09:54 PM" and sort correctly.
It now displays as "2008-09-15 02:30:54.123" and does not sort correctly. I would think that, if anything, the 2nd format would sort correctly.
Is there an option at the server level that sets the create date (or default date) format? Is there something else I'm missing? I really need to get this sorting problem resolved.
Thanks for any input
September 16, 2008 at 10:44 am
I assume you are referring to the crdate from the sysobjects table? Any service packs / patches applied? Changes to database settings?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 16, 2008 at 11:21 am
The data source is sysobjects.crdate. However, I don't care how it is stored or how it appears when I select from the table. I am only interested to the way "create date" column appears (and sorts) when displaying a list of tables (or whatever) for a database.
See screen shots. Sorting appears to be random. I've included 3 shots that are supposed to be sorted by "create date" and they are all different. I sorted them one after the other by clicking the "create date" column heading.
8.00.2039 (SP4)
I have not personally made any changes to any settings or anything else. There are several other people who can make changes to the server/SQL Server/dbs/etc.
September 16, 2008 at 11:30 am
I happenned to me all the time in EM.
The only I found around that was to close EM, open again, then I could hit the column and the sort would actually work at that point (where it didn't before the restart).
I never found why it did that though.
September 16, 2008 at 11:33 am
Interesting and weird....
Michele - did that work? Very curious.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 16, 2008 at 11:54 am
DavidB (9/16/2008)
I assume you are referring to the crdate from the sysobjects table? Any service packs / patches applied? Changes to database settings?
In my case, there was nothing patches wise that could explain that behavior.
The one thing that may explain it though is that my server collation is FRENCH_CI_AS. Maybe that can screw up things a bit, but that's just speculations at this point.
September 16, 2008 at 12:33 pm
Yes, it did work! How utterly bizarre.
Thanks for the suggestions!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply