Post reply

corrupt date column

  • 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.

    ??

  • May 3, 2005 at 10:06 am

    #556575

    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

  • May 3, 2005 at 10:17 am

    #556577

    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

  • May 3, 2005 at 10:47 am

    #556584

    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.

     

  • May 3, 2005 at 2:55 pm

    #556629

    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

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

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