Question :
I am in for a requirement where I need to use EE to capture the Objects Accessed by a particular SQL User.
I want to avoid the action sqlserver.sql_text
, if I use this, I will need to manually scan though the data which may be prone to missing some data or incorrect results.
Is there an alternative to using sqlserver.sql_text
Answer :
I gave up on EE and instead using SQL AUDIT now.
https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine?view=sql-server-ver15