Hi All,
My Requirement is that I have transaction which does inserts some data in table then i need to audit this transaction .I assume that inserting the details of transaction like records inserted in DB is right way to do audit.
Now suppose while doing my first transaction due to network outage my transaction could not complete now how will i audit this.
How can i make sure that if my transaction one fails the other does not ? is it good to combine these two transactions.