Actually, I've just answered this myself.
If I set ANSI WARNINGS ON, no matter what I set ARITHABORT to, a divide by zero error
Set it OFF and ARITHABORT affects the outcome as to whether it just displays a message and continues or errors.
Just annoying now that the mere presence of the command is bu8ilding two execution plans depending on its setting - makes tracing issues just that bit more confusing. :hehe::crazy:
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.