Skip to content

Instantly share code, notes, and snippets.

@timweigel

timweigel/Kendra_Little_better_change_tracking_script_brent_ozar.sql

Last active August 12, 2019 04:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timweigel/4c83bad64932d1ca5afb977cf9189389 to your computer and use it in GitHub Desktop.
Save timweigel/4c83bad64932d1ca5afb977cf9189389 to your computer and use it in GitHub Desktop.
Download ZIP
Kendra Little's better script to review change tracking
Raw
Kendra_Little_better_change_tracking_script_brent_ozar.sql
-- Kendra Little made this; posted at https://www.brentozar.com/archive/2014/06/performance-tuning-sql-server-change-tracking/
SELECT db.name AS change_tracking_db,
is_auto_cleanup_on,
retention_period,
retention_period_units_desc
FROM sys.change_tracking_databases AS ct
JOIN sys.databases AS db
ON ct.database_id=db.database_id;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment