Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


Consider the following scenario:

  • You enable change tracking for a SQL Server database table in Microsoft SQL Server 2012 or SQL Server 2014.

  • The base table contains very few rows of data. For example, the table contains one row.

  • The change tracking side table (internal system table) contains approximately 1,000 rows of data.

  • The syscommittab system table contains lots of rows. For example, the table contains 1.5 million rows.

In this scenario, when you run a query to determine which changes are made by using the CHANGETABLE function, SQL Server might use a plan that uses a hash match aggregate instead of a sort. Therefore, SQL Server returns incorrect information about the changes.


Update information

This issue was first fixed in the following cumulative update for SQL Server:

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included in the previous cumulative update. Check out the latest cumulative updates for SQL Server:

Note You can find information about the latest SQL Server builds from Where to find information about the latest SQL Server builds.


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


Learn about the terminology that Microsoft uses to describe software updates.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!