December 27, 2007

How to reset SQL Server identity column

Generally, to reset an identity column to value n on table XYZ:
DBCC CHECKIDENT('XYZ',RESEED,n)

So, to reset an identity column to value 17 on table XYZ:
DBCC CHECKIDENT('XYZ',RESEED,17)