SQL Server Integration Services

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. Create database:

Enable Change Tracking on Database Level:

After the Change Tracking is enabled on database level, we can edit its […]


T-SQL: Change Tracking – What is this and how it works

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 […]