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ş