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

• jacques.spies

  SSC Veteran

  Points: 270

  More actions

  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.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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

• jacques.spies

  SSC Veteran

  Points: 270

  More actions

  June 21, 2011 at 12:34 pm

  #1342043

  Thanks, will let you know.