Greetings SQL Server Pros,
I ran into a problem that was a first for me today. I queried a table and received this error:
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?
Not yet a pro but by no means a rookie....