I am trying to delete a row in my db and I get this message:
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 filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
I have done a little research and it appears that I need to run the following command:
ALTER DATABASE MyReportingDB SET ARITHABORT ON
Is that so and, if so, why?