For security and auditing purpose, in some cases there would be a need of tracking transaction detail on a table.
The following script achive this using Triggers. The audited
events will be stored in a separate table.
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.