Posts

Showing posts with the label DBCC CHECKIDENT

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