Replication of Triggers

If I create a trigger on a table that is already in a Trans Pub, will
the trigger be replicated?
IF so how can I prevent this?
I have different triggers that affect different tables on the
subscriber and the publisher.
TIA,
Larry...
No, the trigger won't get replicated.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Triggers will be replicated if a new snapshot is generated and you have
elected to replicate User Triggers and you have issued an
sp_refreshsubscriptions.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1129581351.100366.214720@.g49g2000cwa.googlegr oups.com...
> If I create a trigger on a table that is already in a Trans Pub, will
> the trigger be replicated?
> IF so how can I prevent this?
> I have different triggers that affect different tables on the
> subscriber and the publisher.
> TIA,
> Larry...
>
|||thanks guys