I have a trigger on insert but if the trigger fails the insert fails too.
is there a way to let the insert proceed even if the trigger fails?
EDIT: I use a trigger to send a email when a new record is entered. I want the record to be saved regardless if the email was sent or not..
How would I do that from a sp?