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

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.

About cumulative updates for SQL Server

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

Properties

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

ഫീഡ്‌ബാക്ക്