UPDATE Trigger fires on INSERT ????

• BillyWilly

  SSCrazy

  Points: 2304

  More actions

  November 21, 2002 at 7:49 am

  #79872

  Hello... Me again...

  Why do UPDATE Triggers fire when a row is INSERTed ???

  I'm trying to keep an audit trail and log the different events. i.e. - I want to distinguish an INSERT from an UPDATE in an audit table.

  But - the UPDATE fires on every INSERT as well so every insert has 2 events - an INSERT *and* an UPDATE.

  Not really THAT big of a deal - but it's redundant and generally irritating.

  Any ideas ??

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  November 21, 2002 at 8:22 am

  #441984

  Do you have an INSERT trigger that does an UPDATE?

• BillyWilly

  SSCrazy

  Points: 2304

  More actions

  November 21, 2002 at 8:35 am

  #441985

  No... but an insert(into another table)

  To clarify...

  Two Tables:

  1) People

  2) EventLogOfPeopleEdits

  Two Triggers

  1) INSERT on People

  2) UPDATE on People

  *NOTE* NO triggers on the Audit table

  Whenever the People table is edited (INSERT or UPDATE) - the event' occurance is "Inserted" into the audit table.

  That's it...