Sql server audit and change data capture - Join them

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

Closed

as External Help for as External

Type:	Suggestion
ID:	772181
Opened:	11/25/2012 10:30:15 PM
Access Restriction:	Public

Workaround(s)

view

Hi,

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ş

Details (expand)

English

SQL Engine

You will develop the solution.

Improved Administration

0 attachments

Hi,

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.

Thanks!