Reset Identity Column

Resetting the next insert value in SQL Server can be done using DBCC CHECKIDENT.

Here's the syntax from MSDN.

 

DBCC CHECKIDENT 
 ( 
    table_name
        [, { NORESEED | { RESEED [, new_reseed_value ] } } ]
)
[ WITH NO_INFOMSGS ]

Here's how to check the next value.

 DBCC CHECKIDENT ("table_name", NORESEED)

Here's how to reset the value.

DBCC CHECKIDENT("table_name", RESEED, 0)

(*NOTE: The value of the next insert will be 1)

NOTES:

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

http://msdn.microsoft.com/en-us/library/ms176057.aspx