Chad Callihan shows how you can roll your own change tracking with triggers:
Have you ever come across triggers being used to audit table changes? In this post, we’ll look at a few examples of DML triggers in action.
Click through for examples around tracking updates and last edit times, as well as creating audit tables for operations.
If you do go this route, Chad has an important warning. In addition, I appreciate that the statements in this example support multi-row updates. That’s something people often forget when writing triggers.