Set Identity From Zero for Existing Table

DELETE FROM ProjectMaster;
DBCC CHECKIDENT (ProjectMaster, RESEED, 0)

Comments