An error occurred while executing batch. Error message is: Arithmetic Overflow.

• srobinson 596

  Mr or Mrs. 500

  Points: 539

  More actions

  February 20, 2013 at 2:57 pm

  #289806

  Greetings SQL Server Pros,

  I ran into a problem that was a first for me today. I queried a table and received this error:

  Query:

  Select * from customers

  "An error occurred while executing batch. Error message is: Arithmetic Overflow."

  Now there are no calculated fields in this table - there is one clustered index on the table.

  The table itself has 7,174,281 records in it and is about 2240 MB in size. It has plenty of room to grow as well. My first thought was there has to be some corrupted data in there. I have looked into the DBCC Checktable - But I wanted to see if anyone had any recommendations or thoughts on the matter? Has anyone encountered this problem when just selecting from a table without any calculations?

  Thanks,

  Scott

  Not yet a pro but by no means a rookie....

• Erin Ramsay

  SSCrazy Eights

  Points: 9728

  More actions

  February 20, 2013 at 3:51 pm

  #1589763

  Was this by chance originally a SQL 2000 database?

• srobinson 596

  Mr or Mrs. 500

  Points: 539

  More actions

  February 20, 2013 at 3:58 pm

  #1589767

  Yes it was.