November 7, 2010 at 9:34 pm
I am getting the error mention below,while i am creating the index on view.
Msg 1935, Level 16, State 1, Line 3
Cannot create index. Object 'vCurrencytranslationdate' was created with the following SET options off: 'QUOTED_IDENTIFIER'.
Script:
CREATE UNIQUE CLUSTERED INDEX [AI_vCurrencytranslationdate_6928] ON dbo.[vCurrencytranslationdate]
([CurrencyTranslationAsOf] ASC,[KeyCurrency] ASC,[KeyCurrencyFrom] ASC)
WITH (ONLINE = OFF, PAD_INDEX = ON, FILLFACTOR=95, DATA_COMPRESSION = NONE)
I have tried SET QUOTED_IDENTIFIER ON, but it doesnt work.
November 7, 2010 at 10:02 pm
Are you trying to index a view? The problem may be how the the view was created.
November 7, 2010 at 10:39 pm
Agree with Lynn. Check if the ANSI_NULLS and QUOTED_IDENTIFIER options had been set to ON when the View was created.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply