Sql server audit and change data capture - Join them - by Sql server Admin

Status : 

  External<br /><br />
		This item may be valid but belongs to an external system out of the direct control of this product team.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 772181 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 11/25/2012 10:30:15 PM
Access Restriction Public


By using sql server audit , we can only see queries .
And by using CDC, we can capture  the values of columns before or after the  update.
But , both of them must be displayed in the same platform.
When i want to see queries against to a table, i configure sql audit but in the audit file , we can not see the paremeters used in the queries.
Then,We need to configure CDC. This is wasting my time.
Behind this, To see update time of a column, i have to join cdc tables.
One table displays update times and lsn values , another  table displays lsn values and columns values .
But, update time is very basic information. It must be displayed in the same table that shows column values.
Please , simplify our job
Hasan Ali Eriş
Sign in to post a comment.
Posted by Microsoft on 1/3/2013 at 10:12 AM

We've investigated ways to join the SQL Server audit events with CDC and it turns out that this is not as simple as it sounds. The reasons are that the times at which the audit events are generated are different from when the CDC entries are created meaning that you cannot correlate the timestamps for complete accuracy. In addition, we cannot use the LSNs as the Audit event is generated and written at the very start of the transaction and, at that time, the final LSN is not always available.

However, I've enetered this request into our future enhancements list as something that we'll investigate in a future release.