Share via

SQL Server ARITHABOART option

sakuraime 2,351 Reputation points
2021-01-11T09:21:12.19+00:00

what's the actual effect of setting DATABASE OPTION( not session option ) for ARITHABOART on / off?
any example ?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
    2021-01-11T22:58:12.343+00:00

    what's the actual effect of setting DATABASE OPTION( not session option ) for ARITHABOART on / off?

    Under normal circumstances, absolutely none at all.

    If you would connect with a very old client API, for instance DB-Library, you would find that an arithmetic error generates an error if you enable this database option, else not.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Olaf Helper 47,621 Reputation points
    2021-01-11T09:29:18.52+00:00

    See SET ARITHABORT (Transact-SQL): "Ends a query when an overflow or divide-by-zero error occurs during query execution." + Remarlks

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.