Trigger to find which fields were changed on update

• Chris Russell

  SSC Enthusiast

  Points: 173

  More actions

  November 11, 2004 at 1:41 pm

  #84770

  I am trying to create a trigger so that on an Update action the trigger will insert the name of the fields that were changed into one field in an audit table.  For example in table 1 if the city and state fields were changed it would then insert 'city, state' into the 'FieldsChanged' column in my audit table.  FYI, some of my tables have up to 15 columns.  Any help would be appreciated.

   

  Thanks 

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 12, 2004 at 1:05 am

  #529887

  Do a forum search here. This topic has been discussed here many times recently.

  

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]