SQL Server Extended Events to Capture Objects access by a User [duplicate]

Posted on

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.


Leave a Reply

Your email address will not be published. Required fields are marked *