Post reply

Error message is: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

  • June 21, 2011 at 8:21 am

    #240242

    Hi,

    We get the below error when executing the DBCC command on an identified problem table. How do I identified the specific field that is causing this problem and how do I correct it.

    I am not a SQL Expert but do know my way around...

    Your help will be much appreciated.

    Thanks

    Jacques

    dbcc checktable (ASC5)

    Msg 2570, Level 16, State 3, Line 1

    Page (1:193539), slot 8 in object ID 1376723957, index ID 1, partition ID 72057594615693312, alloc unit ID 72057594724417536 (type "In-row data"). Column "CreateDate" value is out of range for data type "datetime". Update column to a legal value.

    There are 26546 rows in 185 pages for object "ASC5".

    CHECKTABLE found 0 allocation errors and 1 consistency errors in table 'ASC5' (object ID 1376723957).

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

  • June 21, 2011 at 12:28 pm

    #1342034

    http://support.microsoft.com/kb/923247

    If you need further help post, but I won't be able to help much this week.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 21, 2011 at 12:34 pm

    #1342043

    Thanks, will let you know.

Viewing 3 posts - 1 through 2 (of 2 total)

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