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.
Article ID: 4010500 - Last Review: 2017, ഫെബ്രു 21 - Revision: 8
Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Standard