October 6th, 2003, 01:02 PM
Arithmetic overflow error converting numeric to data type numeric
I recently upgraded SQL7 to SQL 2000. I've migrated about 50 databases and all are working well except 1. I'm getting and error "Arithmetic overflow error converting numeric to data type numeric". The code was working before I made the upgrade. Anyone have any ideas on what is going on here. Thanks in advance.
November 14th, 2003, 11:13 AM
the error typically occurs when you are trying to pass a numeric value that is too large...
example, trying to pass 12345.67 into a numeric(4,2) would generate the error.