The error was Error: 8908, Severity: 22, State: 6 Table error: Database ID 7, object ID 663725467, index ID 0. Chain linkage mismatch. (3:1056071)->next = (3:1412437), but (3:1412437)->prev = (3:1076856). Any suggestions as to why this might occur?
This is a SQL Server database corruption error. It is very unlikely that it is caused by a client application (they don’t have the power to corrupt databases). It is more likely SQL Server itself that has corrupted its own index in software, or a hardware error on the disk occured - more probable. In any case you will have to go to your latest backup and restore it. Or, run DBCC to try to repair the index.
Thanks for the info. For your information, since it was a “sum index” table, we dropped the table, the removed the sum index field out of the table design, saved, then reapplied. That solved the issue