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

Velja za: SQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 Enterprise Core

Symptoms


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.

Resolution


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

Workaround


To work around this issue, turn on the AUTO_CLOSE database option for the databases that have change tracking enabled.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References