title: Can you update CHANGE_RETENTION on single table?
body: <p>We have change tracking enabled on the database level with a retention period of 5 days. Is it possible to update a single table to 10 days?</p>
  <p>If not what is the query to update the db. Microsoft doco gives this example:</p>
  <pre><code>ALTER DATABASE AdventureWorks2012  
  SET CHANGE_TRACKING = ON  
  (CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)
  </code></pre>
  <p>If I run this the query breaks at line 2 since change tracking is already on</p>