Categories
Database MS SQL Server SQL

Reseed Auto Increment Value in SQL Server

You can reseed the Auto increment field to desire number by using following SQL statement [I think it is specific for SQL Server only] other Database have their own methods.

DBCC CHECKIDENT (<TableName>, RESEED, 0)

Works great for me on Sql Server 2008