Triggers and replication

[corneI]

Hi all...

How are triggers treated during replication?
Are they replicated with the table or not?

Thanks

 

[clapag22]

In my experience they are not.

 

[royjimenez]

u should explain more what u want, 'cause i have worked with trigeers and in many times i've needed to set them NOT FOR REPLICATION, but i am not sure if it's what u want to know.

Regards

The life is too short to cry and long enough to try it... God bless us.

 

[clapag22]

Basically it's like this. If you publish a table that has a trigger, the trigger will not automatically be added as an object on the subscriber table. You can create the trigger on the subscriber table manually. If you create the trigger on the subscriber table and use the "NOT FOR REPLICATION" keyword, any data that is added/changed/deleted on the subscriber table because of replication will NOT cause the trigger to fire.