I’m searching one way to set
ARITHABORT ON for all opened connections, and I found this question.
Some answers says to run the following command, and it really works:
EXEC sys.sp_configure N'user options', N'64' GO RECONFIGURE WITH OVERRIDE GO
But, for me run this command in my company I need some explanations, and I searched a lot of about
user options, but I don’t understand some things:
- Why the value needs to be 64?
- How does it works?
User options is a combination of bit values, for example:
16 ANSI_PADDING 32 ANSI_NULLS 64 ARITHABORT
To turn on only
ARITABORT the value should be
64, and for example for
ARITHABORT it should be
Full list of values available here