>>>Hi,
>>>
>>>Today while reviewing the error log of one of the customers I see the following couple of errors:
>>>

>>>Failed TABLEUPDATE() of WORK_HIS
>>>Index does not match the table. Delete the index file and re-create the index.
>>>

>>>
>>>This customers is using a SQL Server database.
>>>
>>>I have never seen this error.
>>>1. What would cause it (as I understand in SQL Server)
>>>2. How do I find out which Index is the problem (the file has several indexes)
>>>3. How do I delete and reindex a SQL Server table?
>>
>>Haven't had this one since 1994.
>>
>>Somewhere along the way you indexed a cursor and gave the index a name, which became also its filename. Your app crashed, or you did this in two places at the same time, with different cursors. The index was found on disk, and its name now matches the alias of something else. Bang.
>>
>>If you mean to name a cursor's index, use sys(2015).
>
>First, thank you for your quick reply.
>
>So, if I understand you correctly, this is a problem with the VFP cursor, not SQL Server per se, right?

Sure is. VFP wouldn't know anything about the SQL side indexes, they are internal to the server. And if the server reported, you'd have an ODBC error, not VFP error.