Error 602

Severity Level 21

Message Text

Could not find row in Sysindexes for dbid '%d', object '%Id',index '%d'. Run DBCC CHECKTABLE on Sysindexes.

Explanation

This error occurs when 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).

Action

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. Run DBCC CHECKTABLE on sysindexes; also run DBCC CHECKDB and DBCC NEWALLOC.

If the problem persists, contact your primary support provider. Have the output from the DBCC CHECKDB and DBCC NEWALLOC commands available for review.