See SET ARITHABORT (Transact-SQL): "Ends a query when an overflow or divide-by-zero error occurs during query execution." + Remarlks
SQL Server ARITHABOART option
sakuraime
2,326
Reputation points
what's the actual effect of setting DATABASE OPTION( not session option ) for ARITHABOART on / off?
any example ?
2 answers
Sort by: Most helpful
-
-
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.