We track changes at a table level. Meaning, when a change occurs we write the name of the modified table to a table called df_ChangeTracking. This table is cleared when you call the RefreshTheDatabase method.
Mike Brockey
Senior Architect/Owner
EntropyZero Consulting, LLC