Hi Jon,
you probably will say I am wrong, but I can say with 99.99% certainty that this is a hardware problem, most likely in the cabling or a bad harddrive.
>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