1, Change tracking is a lightweight mechanism that associates a version with each row in a table that has been enabled for change tracking.

2, Each time the row is changed, the version number is incremented.

3, Instead of building systems to avoid changes from multiple users overriding each other, applications need only compare the row version to determine if a change has occurred to the row between when the row was read and written.

Configuration:

After change tracking has been enabled for the database, you can choose which tables within a database that change tracking information should be captured for.

Over time, change tracking information accumulates in the database, so you can also specify how long tracking information is retained through the CHANGE_RETENTION option and whether tracking information should be automatically cleaned up with the AUTO_CLEANUP option