Writing
MSSQL–Reset Identity seed
DBCC CHECKIDENT resets an identity seed to a chosen value. A table example explains why the reseed value precedes the desired next identifier after test data is deleted.
Topic
Identity Columns
Database columns whose numeric values are generated from a seed and increment, including how insertion and reseeding affect subsequent values.