Auditing and Change TrackingAuditing and Change Tracking\Change Tracking

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.

Top of Page