:::: MENU ::::

Arithmetic Abort Enabled (ARITHABORT) in SQL Server T-SQL

  • Nov 05 / 2008
  • 0
DBA Interview questions, dbDigger

Arithmetic Abort Enabled (ARITHABORT) in SQL Server T-SQL

You can use Arithmetic Abort option to determine the behavior of certain exception conditions. When set to TRUE in SQL Server Management Studio or ON when using the ALTER DATABASE command, a query is terminated when divide-by-zero error or overflow occurs during query execution. When set to FALSE, a warning message is displayed when one of these errors occurs, but the query, batch, or transaction continues to process as if no error occurred.

Consult us to explore the Databases. Contact us