Tag: Change Tracking

change_tracking_hardened_cleanup_version not incrementing in SQL 2014 SP3

When running manual SQL 2014 SP3 Change Tracking sp_flush_commit_table_on_demand you observe change_tracking_hardened_cleanup_version is not moving forward and syscommittab table not being cleaned up even though auto-clean is enabled. Executing: sp_flush_commit_table_on_demand 1000     The value returned by change_tracking_hardened_cleanup_version() is 1133436.     The value returned by safe_cleanup_version() is 1850878. Executing: sp_flush_commit_table_on_demand 1000     The
Read More »