dba_neo (2/1/2010)
HI,i got the message for all indexes as follows
Executed: ALTER INDEX [IX_ActGUID] ON [dbo].[Primt] REBUILD [SQLSTATE 01000]
Msg 1934, Sev 16, State 1, Line 1 : 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]
This means that you have one or more indexes that have been created on views (or computed) columns with incorrect settings.
Identify those indexed views and recreate them with the appropriate SET options for indexed views. You can find the correct settings in books online.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs