PRB: DBCC CHECKDB Reports Error Message 2501 During Database Activity (288745)

SYMPTOMS

When executing the DBCC CHECKDB command or a Database Maintenance plan that executes a DBCC CHECKDB command on a database while there is activity in that database may report the following error message:

Server: Msg 2501, Level 16, State 1, Line 1 Could not find table named '(Object ID 412557102)'. Check sysobjects.

Any subsequent time that you run the same DBCC command it may report the same error message but on a different object:

Server: Msg 2501, Level 16, State 1, Line 1 Could not find table named '(Object ID 1676080240)'. Check sysobjects.

CAUSE

When running DBCC CHECKDB, the latter could raise spurious or transient errors if there is activity in the database.

In particular, the error described in the "Symptoms" section may occur if an object has entries in other system tables but lacks an entry in the sysobjects system table. For example, the error might occur during the dropping of an object. So, if DBCC CHECKDB is checking the consistency of an object while it is being dropped, the error might occur.

RESOLUTION

Place the database in single user mode prior to running the DBCC CHECKDB command. Placing the database in single user mode prevents any transient messages from the DBCC command. If the database is in a consistent state then the DBCC command does not return any data integrity errors messages.