This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The CheckIdentityValues method verifies the integrity of all identity columns in tables of the referenced database.
The CheckIdentityValues method is implemented using the Transact-SQL DBCC CHECKIDENT statement with no optional arguments specified. The default behavior of the statement resets an identity value if the value supplying the next identity number is found to be less than the maximum value of data in the column. Restrictions on the default behavior apply. For more information, see DBCC CHECKIDENT (Transact-SQL).