Reset Id (identity column) to start counting from one in SQL Server

• 1 DBCC CHECKIDENT('TableName', RESEED, 0)
  
• N This applies to erased tables.
  

References

• http://msdn.microsoft.com/en-us/library/ms176057.aspx
• http://stackoverflow.com/questions/16971/how-do-i-reset-an-increment-identitys-starting-value-in-sql-server