Skip to content

Instantly share code, notes, and snippets.

@timweigel

timweigel/Modify_change_tracking.sql

Created August 12, 2019 04:27
Show Gist options
  • Save timweigel/d76a1db9addc7558df1bc0505127f959 to your computer and use it in GitHub Desktop.
Save timweigel/d76a1db9addc7558df1bc0505127f959 to your computer and use it in GitHub Desktop.
Download ZIP
Script to modify database-level change tracking settings in SQL Server
Raw
Modify_change_tracking.sql
ALTER DATABASE CT_Demo
SET CHANGE_TRACKING
(CHANGE_RETENTION = 14 DAYS, AUTO_CLEANUP = ON);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment