UPDATE failed because the following SET options have incorrect settings: QUOTED_IDENTIFIER, ARITHABORT – PB Docs 2022

Symptom

You may encounter the following error message running
an UPDATE statement:

[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE failed
because the following SET options have incorrect settings:
‘QUOTED_IDENTIFIER, 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.

Environment

Solution

Execute the following statements before the UPDATE call:

See Also

http://msdn.microsoft.com/en-us/library/ms175088.aspx