Hello,

It is a good point to write out the updated/Deleted in XML format (or a common format) into an audit table to track the changes at a later date. This...

Thank you Jeff. I will try that.
What is the difference between Xact Abort and Rollback transaction? Currently, I have all my data processing code in a Try block with...

Yes, at the time of modification. It is a batch and will be run during off hours.
Thanks
MMuthu

Good one! 😀 .. Did not realize how much I needed that laugh..thank you!

MM

A couple of skills that I have used as a database developer

- Thinking of data in sets instead or rows. (this will avoid cursor processing)

- multi table updates and deletes

-...