title: MS SQL Server 2012 change tracking auto cleanup not working
body: <p>I enabled change tracking in my database <strong>Trans</strong> and table <strong>Employee</strong></p>
  
  <pre><code>ALTER DATABASE [Trans]
  SET CHANGE_TRACKING = ON
  ( CHANGE_RETENTION = 5 MINUTES , AUTO_CLEANUP = ON)
  
  ALTER TABLE [Employee]
  ENABLE CHANGE_TRACKING
  WITH ( TRACK_COLUMNS_UPDATED = OFF )
  </code></pre>
  
  <p>I did some update in my employee tables then check data in change tracking</p>
  
  <pre><code>SELECT * FROM CHANGETABLE(CHANGES [Employee], 0) AS ETbl
  </code></pre>
  
  <p>It show data which has changed. I know that cleanup process is asynchronous so I waited for a bit longer than the retention period (lets say 8 Minutes). I still get the result with the query. Cleanup process is executing after 2 days. </p>
  
  <p>I have searched online about it </p>
  
  <p><a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b8b1d5c9-28fe-478e-a07c-6663ddef026f/change-tracking-auto-cleanup-doesnt-work?forum=sqldatabaseengine" rel="nofollow noreferrer">Change Tracking Auto Cleanup doesn't work</a></p>
  
  <p><a href="https://dba.stackexchange.com/questions/94141/change-tracking-cleanup">Change Tracking cleanup</a></p>
  
  <p>but not found proper answer. </p>