#SQL : Re-seed Identity February 07, 2017 Return the current Identity value GO DBCC CHECKIDENT ('TBL_CATClass', NORESEED); GO Reset to 1000. so next insert will give 1001. GO DBCC CHECKIDENT ('TBL_CATClass', RESEED, 1000); GO Read more