Consider the following scenario:
- You enable change tracking for a database in an instance of SQL Server 2014.
- The instance of SQL Server shuts down unexpectedly. For example, the operating system crashes.
- You restart the instance of SQL Server.
In this scenario, the sys.dm_tran_commit_table DMV and the CHANGETABLE function returns incorrect results, or it is missing some records.
To work around this issue, turn on the AUTO_CLOSE database option for the databases that have change tracking enabled.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.