Hello, I'm doing the integration between 2 solutions, where I need to detect the change of a table, and based on the information that is sent I should manipulate another table. I do not have access to the 1st solution to make it change itself, based on this premise I had to create a TRIGGER .
My problem is that when TRIGGER is executed, it does a lock on the 1st solution table which is preventing it from putting the 2nd solution in a production environment ... some way to create a TRIGGER that does not cause a lock, or some other resource that allows me to capture the information in the insertion in the bank and use them without preventing the 1st solution from working?