1

I have merge replication (SQL server 2014) and a table that have 3 triggers that monitor delete, insert and update. All of the triggers are after trigger not instead of.

I'm updating the value on one side and it doesn't update on the second server and when I'm disabling the triggers it's all working. insert and delete doesn't work as well. Any thoughts ?

1

Well as McNets answered all i had to do is alter the script.

ALTER TRIGGER [dbo].[TRG]
ON [dbo].[Table] AFTER DELETE
NOT FOR REPLICATION 
AS
    BEGIN
        BLA BLA BLA
    END

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.