Forum Discussion
Extended Event with app_name doesn't work properly
Hello, When I create an extended event to capture all the SELECT on the instance, it works : CREATE EVENT SESSION [YourSession] ON SERVER ADD EVENT sqlserver.sql_statement_completed( ACTION(sq...
Hello,
I'm having the exact same issue when trying to capture login events - if I include the AppName field in the session, I get no results. If I remove it, I get results as expected.
This is on SQL 2019. If anyone knows why this is happening, some insight would be much appreciated!
Best regards
Hi
I'm getting the same problem when using the "error_reported" event. If I include the "AppName" action, it stops recording events. In fact, there are 2 "AppName" actions, one with a description of "AppName without the full app uri", and one with "Application name without the full app uri". If I include either action, it stops recording errors.
When I remove them it starts working.
This is on a SQL Managed Instance.
Regards
Simon