I am using Schema_Object_access_Group
audit action type. When I run a select, insert, update SQL statement, it records all statements nicely.
For example, captured Sql statement looks like :
UPDATE TOP (200) SomeTable
SET ColName1 = @ColName1
WHERE (ColName2 = @ColName2) AND ...
It is not explaining what was updated value and which row was updated.
I want to capture updated actual value used in SET ColName1 = @ColName1
, is there an audit action type to accomplish the job. I want a way to capture parameters used in any select, update, insert statements.
Willing to use audit events as change log, to track who changed what without using the following:
- Trigger approach to log all changed values
- Change Data Capture "CDC"