DBCC CHECKIDENT

Question

Which command is used reseed the identity value?

Answer

DBCC CHECKIDENT can be used to manually set a new current identity value for the identity column.

DBCC CHECKIDENT ("Sales.ProductType", RESEED, 10);