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