Hi Victor,
Thanks for the reply. I shall give it a try.
TFISHER
>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
Thanks,
TFISHER