Is there way to cleanup change tracking tables manually instead of Auto Cleanup using SYS_CHANGE_VERSION or other options?
Consider we have enabled changetracking for a table x and having data with SYS_CHANGE_VERSION as 1.
Sync the data(SYS_CHANGE_VERSION 1 records) with another database.
Now we have to cleanup the SYS_CHANGE_VERSION 1 records in ChangeTracking table before doing next sync.
Please let us know how we can do this?
Go to the complete details ...