I am using the sql_statement_completed Event in SQL Server 2016 to track all SQL executed on a certain table. I have a Filter on sqlserver.sql_text like %tablename%.
This captures any SQL I execute on the table EXCEPT if a Stored Procedure affects the table.
Is there a way to enhance this Extended Event Session to also track Stored Procedure INSERTs and UPDATEs to my table?
(I have also looked at Change Data Capture, but that doesn't capture the user name that executed the statement)