This might help....
http://msdn.microsoft.com/en-us/library/aa258828(SQL.80).aspx

>Hello,
>
>I have a VFP front end and a SQL 2000 backend. The server the SQL is on has a bad disk and started throwing IO errors (RAID 5 - the bad disk has now been replaced). About that same time, the VFP application that had been working just fine for several years, started crashing when a new record was added to one of the tables. I can add records to some of the tables; however, when I get to a certain point and try to add a record to a specific child table, the program errors and says that it cannot add a new record from a view.
>
>Interestingly enough, I did a backup of the SQL database and put it on my SQL 2008 and it runs just fine.
>
>At one point, I believe I saw a message about sysindex table.
>
>How can I troubleshoot the SQL 2000 database and perhaps re-index and fix the bad table(s)?
>
>Thanks,
>
>TFISHER