title: SQL Server 2008 Change Data Capture, who made the change?
body: <p>I asked a question on SOF a week or so ago about auditing SQL data changes. The usual stuff about using triggers came up, there was also the mention of CDC in SQL Server 2008. </p>
  
  <p>I've been trying it out today and so far so good, the one thing I can't see it supports is keeping a track of who actually made the change. Who executed the statement?</p>
  
  <p>I'm interested to know if anyone has used CDC for auditing and how you kept track of who made the change?</p>