Examples
A. Reset the current identity value, if needed
This example resets the current identity value, if needed, of the jobs table.

USE pubs
GO
DBCC CHECKIDENT (jobs)
GO

B. Report the current identity value
This example reports the current identity value in the jobs table, and does not correct the identity value, if incorrect.

USE pubs
GO
DBCC CHECKIDENT (jobs, NORESEED)
GO

C. Force the current identity value to  30 
This example forces the current identity value in the jobs table to a value of  30 .

USE pubs
GO
DBCC CHECKIDENT (jobs, RESEED,  30 )
GO