I have two tables: dbo.old_roles and 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 .

10x