Trigger question

microsoft.public.sqlserver.programming

9 Sep 2006 11:40 PM

Rob

Using Sql Server 2000...

We have a stored proc that is executed as a Trigger "on Insert"...

If there is any error in the stored proc, then the original Insert fails.
Is there any code that may be added to the trigger or stored proc that would
allow the Insert to commit even if there is an error during the execution of
the stored proc ?

Thanks !