MSG 517 - Datetime column caused overflow

• Brucethedog

  Mr or Mrs. 500

  Points: 530

  More actions

  January 24, 2008 at 9:51 am

  #180788

  New to this forum, hi all.

  An application is failing on a nightly run and from the error log, it says on a View, msg 517 adding a value to a datetime column caused overflow.

  But I cant see the rogue value.

  Any ideas/scripts that I can use to trawl the database tables to find the rogue value that could be throwing up this error?

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  January 25, 2008 at 10:54 am

  #771905

  It is most likely a data type mismatch issue. You may check the data types in your application and SQL Server.

  Here is a link, wishing them helpful.

  http://msdn2.microsoft.com/en-us/library/aa937592(SQL.80).aspx