I create an insert trigger that calls a stored procedure. If an error is encountered when calling the stored procedure, then the trigger appears to affect the insert action such that multiple records are inserted recursively. How can this problem be sorted out.
