Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) Msg 542: An invalid datetime value was encountered. Value exceeds the year 9999 RE: Msg 542: An invalid datetime value was encountered. Value exceeds the year 9999

  • December 21, 2012 at 12:37 am

    #1570752

    David Paskiet (12/20/2012)

    There has to be an easier way! I am all ears and open to a better way!

    See the kb article referenced in the article I mentioned.

    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