Reset SQL Server autoincrement ID
Use the following script to reset the ID to 0 DBCC CHECKIDENT ( TabaleName , RESEED, 0) -------------------------------- Regards Shashika --------------------------------------
This blogs has some interesting topics and useful code snippets