My requirement is to track old rows and modified rows from some particular table and the time when changes are made. Using "Change Tracking" and with help of any system table.
Due to some specific reasons I have to use change tracking as I was told not to use triggers and Change Data Capture.
Right now I am able to fetch current data and which column is modified. But in addition I want to track time of modification and old data.
But if anyone can help me to get any one of these two will be very helpful for me.