Other

Reset Identity Number Value in SQL Server,..
             

     DBCC CHECKIDENT ('dbo.MyTable', RESEED, 1)