I am trying to establish auditing for a SQL Server database without using the trigger approach that is commonly used. I thought I could use CDC and Sql Server auditing. But both technologies do not provide all necessary information in one place. Change Data Capture provides only the data that has changed as complete row in a shadow table but not who did the change. Auditing has a column 'statement' that only shows the statament with parameter placeholders, but therefore the login user who made the change.
But I want to know Who changed what in one place. Is it possible to this with those techniques? Or do I have to use tre trigger approach?