The identity value will be rolled back when the transaction that tried to insert the value into the table is not committed or rolled back