0

I'm updating one column using trigger but I am getting below error .

UPDATE failed because the following SET options have incorrect settings: 'NUMERIC_ROUNDABORT'. 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.

Kindly advice me how to solve.

Thanks,

PraveenKumar.K

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Praveen Kumar
  • 25
  • 5

1 Answers1

0

Try to enable the connection settings:

SET NUMERIC_ROUNDABORT ON

OR

Open the properties of server. Select the tab Connections. And check the numeric round abort option.

Roman Marusyk
  • 23,328
  • 24
  • 73
  • 116