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 ?

Improve this question
1

1 Answer 1

Reset to default
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
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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