I have two tables:
dbo.new_roles. I need to sync between the two.
When created or modified role in one table it should update the other one. To do it I created a trigger in each of the tables.
To prevent a loop, I want to disable the trigger in one table when a trigger is fired from the other table.
When I call to
ALTER TRIGGER statement., I get an error.
What can I do?