Skip to content

Latest commit

 

History

History
32 lines (27 loc) · 1.36 KB

mssqlserver-2508-database-engine-error.md

File metadata and controls

32 lines (27 loc) · 1.36 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
MSSQLSERVER_2508
MSSQLSERVER_2508
MashaMSFT
mathoma
04/04/2017
sql
supportability
reference
2508 (Database Engine error)

MSSQLSERVER_2508

[!INCLUDE 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 [!INCLUDEssNoVersion] before [!INCLUDEssVersion2005], the values for the table and index row counts and page counts can become incorrect. Databases that were created on versions prior to [!INCLUDEssVersion2005] 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.