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 ??