sql server set identity 1 code example Example: reset identity column in sql server DBCC CHECKIDENT ('YourTableName', RESEED, 1)