InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 04:12:32 GMT20http://www.sqlservercentral.com/Forums/Topic930906-1550-1.aspxIf it's just Logon Inforamtion you wish to capture then go for the System Functions.I don't see the point of EVENTDATA() for your requirement. The System Functions will also perform better because the information is extracted from the SQL Srver's System Tables.Fri, 04 Jun 2010 00:02:39 GMTTriggerMehttp://www.sqlservercentral.com/Forums/Topic930906-1550-1.aspxWhich is the preferred way of writing a logon trigger for basic user authentication?Using the EVENTDATA() function and extracting the connection information from the XML or using system functions like this?[code="sql"]select HOST_NAME(),APP_NAME(),SUSER_SNAME(),USER_NAME(),SCHEMA_NAME()[/code]Tue, 01 Jun 2010 11:56:01 GMTMarios Philippopoulos