How to reset Identity Increment value in MS SQL
Posted on March 22, 2008 | 8 Comments
An Identity column in SQL Server is used to auto number the rows. See this great post on Autonumbering & Identity Columns. When you delete rows from the table, the identity will not reset but you have few options of doing it yourself. The SQL Server Management Studio GUI doesn’t support this option…
1. DBCC CHECKIDENT
This is the most easy way, just set it yourself… Continue reading...