Reset Identity column in SQL Server

Just use the following code and run it, your identity columns will be reset to the value you use 

DBCC CHECKIDENT('TableName', RESEED, 0)

Mohammad Abu Hmead