Identifying Orphaned Records in Change Tracking Side Tables (Read‑Only Health Check)

When Change Tracking (CT) is enabled, SQL Server (and Azure SQL Database) stores lightweight change metadata so applications can query “what changed since version X?”. Under the hood, CT maintains: ...