Audit Functionality

• Chris Kalafatis

  Grasshopper

  Points: 11

  More actions

  October 16, 2007 at 6:28 am

  #375903

  Hi,

  I am trying to create a trigger to do the auditing of changes in other tables but I am unable to store the specific changes occured in those tables to my audit details column e.g.:

  ---Trigger details for Insert, Update

  INSERT dbo.AuditTable

  (ID, AudWorkstation, AudTime, AudUser, AudAction, AudDetail)

  SELECT ID, WorkStationID, GETDATE(), LastModified, 'C', 'Missing details part '

  FROM inserted

  Is there a way of getting just the column names that have changed/updated

  and store them into the AudDetail column of my Audit table?

  Thanks

• Greg Snidow

  SSCoach

  Points: 16108

  More actions

  October 16, 2007 at 12:06 pm

  #742465

  Chris, If you search in the above search box for 'audit table' you will see more solutions than you can shake a stick at. I can tell you one thing though, you really do not need to audit inserts, since they will be in your production table, and tracking them will use space.

  Greg

  Greg
  _________________________________________________________________________________________________
  The glass is at one half capacity: nothing more, nothing less.