Triggers Atomicity property

• carloarango@hotmail.com

  SSChasing Mays

  Points: 628

  More actions

  April 16, 2010 at 10:17 am

  #220612

  I created an INSERT TRIGGER that would perform some other process with the INSERTED data, affecting other tables in a different DB; when testing I noticed that if the process in the trigger fails the record that fired the trigger doesn't get inserted (Atomocity property I guess); is there a way I can bypass that? I want to insert the record no matter what, even if the process within the trigger fails.

  Any ideas?

  Thanks

• spaghettidba

  SSC Guru

  Points: 105712

  More actions

  April 16, 2010 at 10:34 am

  #1153006

  Have you tried handling errors in the triggers with TRY/CATCH?

  You could ignore errors in the catch block.

  -- Gianluca Sartori