Could not find row in sysindexes for database ID %d, object ID %ld, index ID %d. Run DBCC CHECKTABLE on sysindexes.
This error occurs when Microsoft® SQL Server™ cannot find a row in the sysindexes table for a needed table or index (for example, when executing a stored procedure that references a table that has been dropped).
If the error occurs because a stored procedure references a dropped table, drop and re-create the stored procedure. This error may also occur in conjunction with other error messages that better point to the root cause of the problem. Execute DBCC CHECKTABLE on sysindexes; also execute DBCC CHECKDB.
If the problem persists, contact your primary support provider. Have the output from the DBCC CHECKDB statement available for review.
| ALTER PROCEDURE | DROP PROCEDURE |
| CREATE PROCEDURE | Errors 1 - 999 |
| DBCC CHECKDB | Reporting Errors to Your Primary Support Provider |
| DBCC CHECKTABLE | sysindexes |