I have two databases with identical tables called comments. I set up a trigger on each that will insert any rows added to that table to the table in the other database. This works great. Whichever database I am logged into when I create a new comment it is also inserted in the other table. The problem is when I try to modify a comment. I am getting a key violation because the insert trigger is executing. I am wondering how I keep this trigger from executing. I also need to add another one that will update the other table when one is modified.