• adonado (5/8/2009)


    I want to know how can i store on a column the name of the column that was modified (updated) on the table that I'm auditing, in order to track only the column that was update, the previous value and the new value, date, time and user that did the update.

    What do you want to do if more than one column was updated?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]