• GSquared (1/9/2012)


    Audit logging doesn't need to use the "inserted" data. You already have that in the table you just updated. Logging it just increases the size of the log and doesn't actually add any value to it.

    If you're using the OUTPUT clause, you may want to capture both, because it's possible that there are other queries that won't create the audit information and you may want to capture all of the information at the time of the original update.

    Using a trigger, it will obviously fire any time there is an update, so you wouldn't need to capture the inserted data.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA