Data can be converted from one numeric type to another. If the new type is an exact numeric whose precision or scale is not sufficient to hold the data, errors can occur. Use the arithabort and arithignore options to determine how these errors are handled.
The arithabort and arithignore options
were redefined in SQL Server release 10.0. If you use these options
in your applications, examine them to make sure they are still functioning
correctly.
