When
auditing is not required but tracking of changes is desired, activate the
Change Tracking System Default. When active, changes to most of the database
tables are tracked, keeping a history.
Note: Change tracking operates on the
database level, which means that the tracking mechanism is not limited to
screens that show the actual change tracking history icon/button. Unless a
table/column is not included in tracking, any change to it, from MET/TEAM,
MET/CAL, or running a query in SQL Server Management Studio is captured. For
the latter case, the user that made the change or the application the change
came from, may be inaccurate, because the information may not be available.
Related Topics