====== How To Reset Identity Column Value in SQL Server ======

===== Check Identity Value =====
<code>
DBCC CHECKIDENT (tablename, NORESEED)
</code>

===== Set Identity Value =====
<code>
DBCC CHECKIDENT (tablename, RESEED, identvalue)
</code>

This means that the number you input in place of 'identvalue' should be the CURRENT last index. The next value will be identvalue + 1. If you enter 999 then the next record inserted will have a value of 1000.

To reset a table:
<code>
DBCC CHECKIDENT (tablename, RESEED, 0)
</code>

===== Sources =====
http://www.howtogeek.com/howto/database/reset-identity-column-value-in-sql-server/