Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eurob
Posting Yak Master
100 Posts |
 Posted - 2006-02-23 : 10:48:27
|
| I try to create an index on a view but I get the msg:CREATE INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.I googled on it and it seems that I have to do some adjustments on the DB, I just don't know exactly which ones I have to set or change. Anyone had the same experience ?robert |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-23 : 11:36:25
|
| Worked in one place that used indexed views, was a hassle but got there in the end..From BOL..These SET options must be set to ON when the CREATE INDEX statement is executed: ANSI_NULLSANSI_PADDINGANSI_WARNINGSARITHABORTCONCAT_NULL_YIELDS_NULLQUOTED_IDENTIFIERS The NUMERIC_ROUNDABORT option must be set to OFF. |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-02-23 : 13:56:31
|
| Rick, you'd be the one of the first I've heard about that battled through all the hassle. I may be a little biased but if you want my comments on indexed views see the bottom of this thread:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62255Be One with the OptimizerTG |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-24 : 08:48:24
|
| Yeah, the company I was working for at the time really wanted to use it for a denormalised database we had, we managed to get it all sorted in the end though (after about a month of complete and total hassle)..Nothing else would have worked in this case, we tried everything else we could think of at the time..They do work well if you get them right and you are sure the structure is never going to change.. Otherwise, they are just not worth the time or hassle.. |
|
|
|
|
|
|
SET OPTIONS incorrect