The following error message is recieved when trying to optimize a MERGE statement...
** ERROR:[Invalid SQL statement.
MERGE failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'. 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.
Â
Check the 'ANSI_NULLS' and 'QUOTED_IDENTIFIER' set options to make sure they are configured correctly, as specified in the error message.
