Change Data Capture is provided by SQL Server 2008. No more need for setting complicated triggers on your database object. It can make auditing database records so much easier.
The
default retention value i.e. the time for which audit logs will be stored in the database is 4320 minutes = 72 hours = 3 days.
However it is configurable by
using
sp_cdc_change_job @job_type='cleanup', @retention=minutes
