Hi,
We have enabled Change Tracking feature in SQL Server 2012 Express edition. During testing, we have identified only one record was not tracked by change tracking. (Meaning same was not retrieved with ChangeTable() function)
Following are verified / ensured in this environment,
-> Change Tracking was not disabled at any given time, ruling out the possibility of excluding that table from tracking.
-> AutoClenanUp also might not have cleaned the data, as we have the previous and next transaction records in that scope.
-> SP1 was not installed, when this issue was observed.
Can somebody help us to identify the root-cause for this issue?
Thanks.
...
Go to the complete details ...