This is something that I am frequently being asked about, so I decided to post the simple solution.
For SQL Server table columns that have the IDENTITY property enabled, their respected values are being auto-incremented according to the IDENTITY’s incremental value.
The seed value is the value that is used for the very first row inserted into the table.
Therefore, if at some point all table records are cleared, there might be the need to reset the seed value back to zero or some other value.
Here is how we can reset the IDENTITY value with a simple SQL statement:
DBCC CHECKIDENT ('table-name', RESEED, new-value)
It has to be mentioned that the next value that will be inserted on the table would be the value of ‘new-value’ + 1. So for example if the new-value is 0, the next row value will be 1.