Pages

Google Analytics Alternative

Search This Blog

Thursday, March 29, 2012

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);

No comments: