When a table's primary field is to auto increment with a seed and you are deleting the records from the table. Now you need to reset the primary field value to 1. The code given below is useful.
 

   1: DBCC CHECKIDENT (tblName, RESEED, 0)