Microsoft KB Archive/242953

= SMS: "Table Corrupt" When Running DBCC Checkcatalog Against SMS Database =

Article ID: 242953

Article Last Modified on 11/30/2007

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Service Pack 3
 * Microsoft Systems Management Server 2.0 Standard Edition
 * Microsoft Systems Management Server 2.0 Service Pack 1
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q242953



SYMPTOMS
Database consistency checks (DBCCs) may produce error messages when they are run against a Systems Management Server (SMS) 2.0 SP1 SQL 7.0 database, even though the database is working correctly. For example, when you run DBCC "checkcatalog" against an SMS SQL 7.0 database, an error message similar to the following message may be generated:

Server: Msg 2513, Level 16, State 15, Line 1

Table Corrupt: Object ID 322100188 (object 'Summarizer_ComponentTallys') does not match between 'SYSREFERENCES' and 'SYSCOLUMNS.'.

DBCC results for 'current database'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

However, using the database indicates that the database is not corrupted, and all other DBCC checks, including DBCC "checkdb" run without any error messages.



WORKAROUND
You can ignore this error message. The SYSREFERENCES and SYSCOLUMNS tables are created by SQL in each database. These tables are not used by SMS.



STATUS
This problem is resolved in SQL 7.0 Service Pack 2 and later.



MORE INFORMATION
From SQL books online:

sysreferences (T-SQL)

Contains mappings of FOREIGN KEY constraint definitions to the referenced columns. This table is stored in each database.

syscolumns (T-SQL)

Contains one row for every column in every table and view, and a row for each parameter in a stored procedure. This table is in each database.

Additional query words: prodsms

Keywords: kbbug kbdatabase kbinterop kbnofix kbserver kbsmsadmin kbsmsutil KB242953

-

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

© Microsoft Corporation. All rights reserved.