Generic Audit Trigger

• YSLGuru

  SSC-Insane

  Points: 21661

  More actions

  April 1, 2010 at 10:26 am

  #1144210

  Jeff Moden (8/14/2007)

  ---

  Thanks for the awesome compliment, Kenny... and thanks for the patch to the code!

  Jeff - I just read over this thread and was curious if there was a final code set for what you and the otehr guy were working on back and forth in the trhead. I could use a geenric auditing item like this.

  Thanks

  Kindest Regards,

  Just say No to Facebook!

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  April 1, 2010 at 11:10 am

  #1144278

  YSLGuru (4/1/2010)

  ---

  Jeff Moden (8/14/2007)

  ---

  Thanks for the awesome compliment, Kenny... and thanks for the patch to the code!

  Jeff - I just read over this thread and was curious if there was a final code set for what you and the otehr guy were working on back and forth in the trhead. I could use a geenric auditing item like this.

  Thanks

  I've got "pieces and parts". The real key here is that I don't use generic trigger code because < insert drum roll here > , it's relatively too slow.

  The best thing to do is to write code that will write audit trigger code for you.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)