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