Error:
ALTER INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. 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. [SQLSTATE 42000]
Resolution:
SET QUOTED_IDENTIFIER ON;
GO
...
SET QUOTED_IDENTIFIER OFF;
GO
Sources:
https://www.sqlserver-dba.com/2012/12/sql-server-alter-index-failed-due-to-quoted-identifier-.html
Comments