I have a problem with Change Tracking in SQL Srver 2008.
One of my databases had change tracking enabled and ws also configured for DB mirroring. After a service restart the DB failed over to the mirror and when the service was up again i failed it back - all this worked ok.
Now, after that incident the change tracking was messed up.
CHANGE_TRACKING_CURRENT_VERSION() retuens a lower value than CHANGE_TRACKING_MIN_VALID_VERSION which is of course wrong.... but the current version grows so change tracking should be enabled.
When i look at the properties for the database however, the change tracking seems to be disabled and if I try to re-enable it i get this error message: "Change tracking is already enabled for database".
The problem with current beeing reset after a failover is a known issue so that is explainable..... but the problem now is how i reset the whole thing.... Any suggestions?