MSSQLSERVER_2508
Applies to: 
SQL Server
Details
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 2508 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | DBCC_OUT_OF_DATE_PAGE_OR_ROW_COUNT |
| Message Text | The %.*ls count for object "%.*ls", index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) is incorrect. Run DBCC UPDATEUSAGE. |
Explanation
In versions of SQL Server before SQL Server 2005 (9.x), the values for the table and index row counts and page counts can become incorrect. Databases that were created on versions prior to SQL Server 2005 (9.x) may contain incorrect counts. DBCC CHECKDB has been enhanced to detect these errors and returns this warning message when the error encountered.
User Action
Run DBCC UPDATEUSAGE against the specified object or index, or against the database in which the object is contained to correct the invalid counts.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for