Hi Jon. Is there anything unusual about the index expressions on that table? Have you run a disk check and surface check on the disk? Disk optimizer?
>Hi all,
>
>I have a client who keeps getting a Fatal Exception error when saving a record.
>
>I have establised that this error is occuring due to the index on the table being corrupt, reindexing resolves the problem. However, this seems to happen about once a week and what I really need to know is why is the index is becoming corrupt so frequently.
>
>The system has over 100 tables and it only seems to be this table that is getting corrupt.
>
>The table that becomes corrupt is used for holding Audit Log information and is therefore freqently written to. A maximum of 15 users can be using the system at any one time.
>
>I know how to fix the Fatal Exception error, however I'm really looking for some ideas\areas on why the index keeps becoming corrupt.
>
>Are there any common areas\known problems that may result in an index becoming corrupt?
>
>Any thoughts would be greatfully received.
>
>Jon
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.