Auditing using Triggers

• rajankjohn

  SSCertifiable

  Points: 5061

  More actions

  May 6, 2008 at 8:46 am

  #185097

  Has anyone tried to track logon/logoff events using triggers; I mean DDL type triggers? Can we use the TRC_SECURITY_AUDIT directly, or should we create event notifications specifically? Any help is appreciated!

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  May 7, 2008 at 1:42 am

  #811610

  With SP2 for SQL 2005 MS introduced LOGON Triggers.

  See

  http://msdn.microsoft.com/en-us/library/bb326598.aspx

  or

  http://www.sqlservercentral.com/articles/SQLServerCentral.com/sqlserver2005logontriggers/2366/

  [font="Verdana"]Markus Bohse[/font]

• rajankjohn

  SSCertifiable

  Points: 5061

  More actions

  May 7, 2008 at 2:36 am

  #811625

  Thanks Marcus, I missed that! Thankyou