table requires rebuild - secondary index does not match ... 
Author Message
 table requires rebuild - secondary index does not match ...
I have a table of which the header gets corrupted.

Before this happens, I do a tools, repair, verify
and what message do I get?

secondary index "naamindex" does not match "naam" field record
1832

What's the value of field "naam"?

Very simple : andr. The accent makes the index corrupt.

Does anyone know of a workaround?

Thanks,

carl



Mon, 12 Oct 1998 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Index dees not match the table, delete the index file and re-create

2. rebuild or not rebuild index file, when ?, how?

3. Network error: index does not match table

4. ERROR #114: Index does not match the table.

5. Space Required to rebuild nonclustered index

6. 6.5 - time requires to rebuild index

7. Does rebuilding indexes also require upating statistics?

8. Query timeout requiring index rebuild

9. Descending secondary index not working

10. TUtility 5.0 Error--"Secondary index %s does not match table." Why?

11. Difference in ranking results from a full index rebuild verses an incremental rebuild


 
Powered by phpBB® Forum Software