SQL Server ARITHABOART option

sakuraime 2,326 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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,947 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 44,936 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

    1 person found this answer helpful.

  2. Erland Sommarskog 112.6K Reputation points MVP
    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.

    1 person found this answer helpful.
    0 comments No comments

Your answer

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