Hi All,

Users receive the following message when trying to update SQL Server indexed views:

UPDATE failed because the following SET options have incorrect
settings: 'ANSI_NULLS, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL,
ANSI_WARNINGS, ANSI_PADDING'. 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. (severity 16)

I am not able to duplicate this error on my end. Are those options specific to the connection? Do I have to set them on the DB level?

Thank you,
DAniel