title: CDC job still tracking changes done on table(enabled with CDC) SQL server
body: <p>I currently have CDC enabled on a table for tracking changes done, however while playing around with it. I found out that even though I disable the CDC capture jobs associated with the table, the CT table still tracks all the <em>INSERT</em> and <em>UPDATE</em> done on the table its tracking. I believe that its this capture job that captures changes since this job is always in <em>executing</em> state. So just wondering as to why it still captures even when disabled.</p>
  
  <p>Is this expected? Is there anyway to disable CDC tracking on the table without using <code>sys.sp_cdc_disable_table</code>?</p>
  
  <p>Also, while we are at it would just like to ask how to possibly induce an error to stop this job automatically since I'm trying to recreate an error that made the CDC job stop.</p>