reset sql server identity counter code example Example: sql server reset identity DBCC CHECKIDENT ('table name', RESEED , 0)