Reset SQL Server autoincrement ID

 Use the following script to reset the ID to 0


DBCC CHECKIDENT (TabaleName, RESEED, 0)

-------------------------------- Regards Shashika --------------------------------------