Home Forums SQL Server 2008 SQL Server 2008 Administration Logon triggers - using EVENTDATA() versus system functions (SUSER_SNAME() etc.) RE: Logon triggers - using EVENTDATA() versus system functions (SUSER_SNAME() etc.)

  • June 4, 2010 at 12:02 am

    #1176338

    If 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.

    Kindest Regards,