when we restored a db into sql 2005.. we get the following error:
- The CREATE UNIQUE INDEX statement terminated becaus a duplicate key was found for the object name '...$VSIFT$1' ande the index name 'VSIFTIDX. The duplicate....
I looked into the table, and there are 3 keys with the same sumindexfield, but on different keys. When is set MaintainSIFTindex to NO, the keys are created.
Now my question: how can this happen?
Secondly, when i disable maintainSIFTindex, do the simindexfields still get created and are the usable without this?