Does anyone know why arithabort is defaulted to OFF in SQL Server?Chavi (chavi.tyberg@.gmail.com) writes:
> Does anyone know why arithabort is defaulted to OFF in SQL Server?
Probably legacy. All SET options were OFF from the beginning. Then with
SQL 7, they started to have all ANSI options on, except
IMPLCITI_TRANSACTIONS and CURSOR_CLOSE_ON_COMMIT. ARITHABORT is not an
ANSI_OPTION.
The good news is that in SQL 2005, there is no longer any requirement
for ARITHABORT to be on for indexed views and that. The one thing
not covered by ANSI_WARNINGS in SQL 2000 is now covered in SQL 2005.
(That thing is the check for domain errors, as in sqrt(-1).)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment