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