How To Get IDENTITY_INSERT Incriment Primary Key ID Roll Back When The Application Fails.

 My question is how to get IDENTITY_INSERT Incriment Primary Key ID  roll back when the application fails.

Using TransactionScope with single connection in DataObject. I am trying to insert row in two dataTable  using its own tableAdapter (two tableAdapter).

I have Product table with ProductID primary key with incriment identity.  and that ProductID is used to insert row in ProductHistory Table. Lets say Product table has the last ProductID=8 (8 rows) and the next ProductID will be 9.

When I insert row in both table and if the second table insert fails both gets roll back (which is good). but when I insert again another time the Product ID=10 not 9. Is there any way to roll back the ProductID in Product table so when i insert next time it has incriment number instead of gap.