Sample Header Ad - 728x90

Error while creating Extended Events on 2008 SQL Server

2 votes
1 answer
278 views
I am trying to create an extended event to capture the login information of my server. While creating an extended event on SQL 2008 using the below query CREATE EVENT SESSION [SA_Monitor] ON SERVER ADD EVENT sqlserver.login( ACTION(sqlserver.server_principal_name,sqlserver.sql_text,sqlserver.username) I am getting the following error. > The event name, "sqlserver.login", is invalid, or the object could not > be found. On Initial investigation I found that creating extended events using SSMS was introduced from 2012 and the only method to create EE is through SQL query. Is there a generic query that can help me capture this information in the 2008 server.
Asked by l.lijith (918 rep)
Jan 30, 2020, 12:51 PM
Last activity: May 14, 2025, 07:04 AM