>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

I believe (not verified) that you can set these properties per connection. Of course, you can also have them set on the DB level.