Logon triggers - using EVENTDATA() versus system functions (SUSER

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Logon triggers - using EVENTDATA() versus...

Logon triggers - using EVENTDATA() versus system functions (SUSER_SNAME() etc.)

Rate Topic

Display Mode

Topic Options

Author

Message

Marios Philippopoulos

Posted Tuesday, June 01, 2010 11:56 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:10 AM
Points: 1,824, Visits: 3,477

Which 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?

select HOST_NAME(),APP_NAME(),SUSER_SNAME(),USER_NAME(),SCHEMA_NAME()

__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation

Post #930906

TriggerMe

Posted Friday, June 04, 2010 12:02 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:19 PM
Points: 871, Visits: 273

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,

Post #932593

« Prev Topic | Next Topic »

Permissions