Thanks for the reply.

Of course, we read the BOL. But it does not mention explicitly the rollback scenario. Also looking for any alternatives.