I'm moving various dbs from SQL7 -> SQL2K, and trying to make use of various 2K features as I go. One thing that would improve performance quite nicely is materialised views, but every time I try to create on I get the following message:

Cannot create index. Object 'Revenue_Expense_VW_inc_ByBroker' was created with the following SET options off: 'QUOTED_IDENTIFIER'.

Do materialised views require that 'QUOTED_IDENTIFIER' be true/on, and if so why (& how do I accomplish it)?

Chris

There are two secrets to success in this world:
1. Never tell everything you know

__________________
There are two secrets to success in this world:
1. Never tell everything you know

According to BOL: "The ANSI_NULLS and QUOTED_IDENTIFIER options must have been set to ON when the CREATE VIEW statement was executed."

Either your server connection must have these on by default or you need to execute a SET QUOTED_IDENTIFIER ON (and ANSI_NULLS) in the procedure that contains the CREATE VIEW statement.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com