Does SQL Server support a feature to track audit, BOTH row update and schema changes in the same place
<p>I currently capture audit history of billing changes tables data in a SQL Server database, on the row updates/inserts. This question/answer has been beaten to death (but also evolved both from Microsoft SQL Server features, and features for user defined solutions).</p>

<p>However, I am finding in my scenario, frequent schema changes. So, I am manually dropping and recreating the shadow audit tables, which is getting tedious over many tables.</p>

<p>Is there turn-key feature or plugin with SQL Server that does both with ease from dev perspective/non-dba, i.e. capture both the meta changes and full row update/transaction, in the same place / one stop shopping?</p>

<p>There seem to be a many ways, but I want one solution the. The way I do this now, is I add a new column to the shadow table as the schema grows, and look for when the schema was changed in the audit table.</p>

<ol>
<li>CDC - Change Data Capture, but drops the tables on cleanup</li>
<li>Audit Triggers</li>
<li>Audit Table Feature</li>
<li><a href="http://bit.ly/1PRw5W0" rel="nofollow">AutoAudit</a>: love the options , not updated, performance seems slow</li>
<li><a href="http://bit.ly/1SDb1Do" rel="nofollow">EF Audit tracking</a> changes change tracking </li>
</ol>