FIX: DBCC Checkident Always Reports the Seed Value as Current
Article ID: 151591
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q151591
BUG#: 14759 (6.50)
SYMPTOMS
When running dbcc checkident, the current identity value will always be
reported as the original seed value.
Checking identity information: current identity value '1', maximum
column value '14'. DBCC execution completed. If DBCC printed error
messages, see your System Administrator.
The rest of the dbcc completes successfully and if need be the next
identity value is corrected. However, the message will continue to report
the seed value as the current identity value.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5. This problem was corrected in U.S. Service Pack 1 for
Microsoft SQL Server version 6.5. For more information, contact your
primary support provider.
Keywords: kbbug kbfix kbprogramming KB151591