T-SQL: Change Tracking Retention Period – How Long the Changes are Kept
As we mentioned in Change Tracking – What is this and how it works, the retention period is the one that determines how long the changes are kept.
As we mentioned in Change Tracking – What is this and how it works, the retention period is the one that determines how long the changes are kept.
Change tracking was introduced in SQL Server 2008. This is a tool that keeps the fact that there are changes in tracked tables for a specified period of time. It doesn’t show what the changes are, it tells that a data has been changed. It answers if a change has been […]