FIX: Sys.dm_tran_commit_table DMV and CHANGETABLE function return incorrect results if SQL Server shuts down unexpectedly


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.


This issue is fixed in Cumulative Update 4 for SQL Server 2014 Service Pack 2.

About cumulative updates for SQL Server


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.



Id. de artículo: 4010500 - Última revisión: 21-02-2017 - Revisión: 8

Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Standard