I am trying to use a trigger (ex: Table_A) to initiate a program when Table_A's record is created or updated, to assign a guid value to a field in the record i am working with, then generate xml of the record and put it on a queue.
I want the trigger to initiate when the record is first created or changed, however since im having to assign a guid value to a field in the record whenever i do this, ill be recursively triggering the write trigger every time i update the guid field. is there a way i can tell the logic in the trigger procedure to not trigger itself during a specific assign statement in the trigger procedure? I think i can see how to do this without this ability but it would be a lot simpler if i could simply disable the trigger from happening inside the trigger itself.
I want the trigger to initiate when the record is first created or changed, however since im having to assign a guid value to a field in the record whenever i do this, ill be recursively triggering the write trigger every time i update the guid field. is there a way i can tell the logic in the trigger procedure to not trigger itself during a specific assign statement in the trigger procedure? I think i can see how to do this without this ability but it would be a lot simpler if i could simply disable the trigger from happening inside the trigger itself.