Home Forums SQL Server 2008 SQL Server 2008 - General can dml triggers statements get logged RE: can dml triggers statements get logged

  • January 21, 2013 at 7:55 am

    #1579264

    sej2008 (1/21/2013)

    I want to understand since dml triggers are using data modification statements

    are they logged in log file and if yes when?

    and can we log those trigger events in auditing in system event log in sql 2008?

    Just one point...

    The transaction log is not an audit log. It's not there so you can see what happened. If you want an audit log, then configure one using trace, extended events, CDC, change tracking or SQL Audit.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass