Error 602

Troubleshooting SQL Server

Troubleshooting

Error 602

Severity Level 21
Message Text

Could not find row in sysindexes for database ID %d, object ID %ld, index ID %d. Run DBCC CHECKTABLE on sysindexes.

Explanation

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).

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. 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.

See Also

ALTER PROCEDURE

CREATE PROCEDURE

DBCC CHECKDB

DBCC CHECKTABLE

DROP PROCEDURE

Errors 1 - 999

Reporting Errors to Your Primary Support Provider

sysindexes