1/*If you have delete all the rows in a table, and you want to reset the identity column value, use this*/
2DBCC CHECKIDENT ('Table_Name',RESEED,0)
1USE <databasename>;
2GO
3DBCC CHECKIDENT ('<tablename>.<columnname>', <value>, <incrementby>);
4GO