Simple Trigger question ?

[pvmurphy]

On an Insert trigger, what must I do to insure that the Insert completes, even though my code to update tables on a linked server may fail. Would the after trigger be applicable here?

Thanks,

Jim

 

[NathanGriffiths]

If I understand you correctly then yes, you can use an AFTER INSERT trigger to update tables on a linked server in this manner i.e. the AFTER trigger will only fire if the the original INSERT statement completes successfully.

cheers

Nathan

Nathan

----------------------------------------
Want to get a good response to your question? Read this FAQ! -> faq183-874
----------------------------------------

 

[pvmurphy]

If the trigger fires after the insert, it there is then a problem, I don't want the insert to get rolled back.