During the installation of an application, I receive the following error;
System.Data.SqlClient.SqlException: CONDITIONAL failed because the following SET options have incorrect settings: 'ANSI_WARNINGS'. 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.
I believe this occurs during an INSERT or UPDATE to a table used by the application but am still verifying this.
Doe anyone have any suggestions on why this error would occur.
I have tried setting the ANSI_WARNINGS to 'True' which did not solve this error generation.