>Hi,
>
>Is there any (quick easy) way to tell from within a trigger which event caused the trigger to fire? i.e. - if I have a trigger on update/insert - I would like to know whether it was an insert or an update that caused the trigger to hit
>
>TIA!

declare ninsert int, ndelete int
select ninsert = count(*) from inserted
select ndelete = count(*) from deleted

if ninsert > 0 /* insert trigger */
if ndelete > 0 /* delete trigger */
if ninsert > 0 and ndelete > 0 /* update trigger */

HTH.