• You can use table variable for ur tracking data, u can insert the tracking data into it between the transactions and finally it wouldn't be removed after even roll back of the transaction. At the end, after the transaction, u can insert the data from ur table variable to ur physical tracking table.

    hope it helps.

    -Shashi