Data Aging fails with error "DELETE failed because the following SET options have incorrect settings: ARITHABORT. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. [SQLSTATE 42000] (Error 1934). The step failed"
The ARITHABORT Database option is set to OFF
ARITHABORT must be ON when you are creating or changing indexes on computed columns or indexed views.
Note: the default ARITHABORT setting for Compatibility Level SQL 2000 is OFF, the default ARITHABORT setting for Compatibility Level SQL 2005 and greater is ON.
Workaround 1
On the SQL Server with the MessageStats database, open SQL Server Management Studio.
Note:The Compatibility Level for the MessageStats database should match the version of SQL Server installed.
Workaround 2
On the SQL Server with the MessageStats database, open SQL Server Management Studio.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy