Microsoft KB Archive/288745

= PRB: DBCC CHECKDB Reports Error Message 2501 During Database Activity =

Article ID: 288745

Article Last Modified on 10/31/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q288745



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 &quot;Symptoms&quot; 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.

Additional query words: dbcc checkdb 2501

Keywords: kbprb KB288745

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.