I have several SQL Server 2008 servers installed on several machines that perform information synchronization processes every night. All work correctly except one that was recently installed in which I get the following error:
INSERT error because the following SET options have incorrect settings: 'NUMERIC_ROUNDABORT'. Check that the SET options are correct and can be used with indexed views and / or indexes in calculated columns and / or filtered indexes and / or query notifications and / or XML data type methods and / or spatial index operations.
I have also observed that in another process I obtained an arithmetic overflow error by launching a query that I also cast on all servers. The error was given by making an AVG of a value. But as I comment only on this server.
I thought it was due to the configuration of the server but I have reviewed the configurations on several servers and they are the same. I do not know if I check what causes the error. Attached two captures.
