corrupt date column

Question

corrupt date column

Kevin Priller

Grasshopper

Points: 16
More actions
May 3, 2005 at 9:28 am

#166750

SQL Server 2000 Ent
I am seeing random pieces of code appended to some of the dates in the 'Create Date' column for tables, views, sps. I see this on most of the DBs.
Examples:
07/18/2003 9:17:56 AMy_netsend_operator
08/06/2000 1:29:12 AMn_date
Also When accessing the restore DB, the First backup to restore dropdown box is not legible (but is functional)
The OS and SQL were reinstalled recently and the master db was not restored from backups and has these same issues.
??

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 1

Hello,

Did you check if it is a data storage issue or presentation issue? I mean, did you use Query Analyzer to select from sysobjects?

select

crdate from sysobjects

Please, do it using client tools from another computer to make sure your client tools are OK. Then you will know if the create date is stored incorrectly (corrupted) or it is Enterprise Manage presentation issue, though never have heard of something similar.

Yelena

Regards,Yelena Varsha

DavidT SSCommitted Points: 1727 More actions · Answer 2

I see the exact same thing. I started seeing it only after I had had installed the beta version of SQL Server 2005 client tools.

I believe it is an Enterprise manager presentation issue connected to this.

Connecting to the same database from another machine without 2005 installed displays correctly.

David

Kevin Priller Grasshopper Points: 16 More actions · Answer 3

Thanks! That was it. (tested from another box with no issues)

Currently playing with Visual Web Developer 2005 Express Edition Beta (includes SQL 2005)

I feel much better now.

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 4

I am glad that you feel much better now. I really don't want to interfer with your cheerful mood. I just want to mention that when I used 2005 Enterprise Manager from Developer Edition Beta 2 on one workstation and tried to change user's password on registered SQL Server 2000 on another server (2 clicks, really...) it got it the way that both new and old password did not work. I had to use Enterprise Manager for SQL Server 2000 from the third workstation to reset the password.

Have Fun

Yelena

Regards,Yelena Varsha