Replication - update on TARGET srv

I have replication (Primary-Target) When updates at PRIMARY occur - TARGET server receives this updates and updates its table - tab1, but trigger (on TARGET ) on this table (CREATE TRIGGER TrName UPDATE OF col1 ON tab1 ..........) this trigger does not work when updates occur. But when I make updates on TARGET by myself - this trigger works! What is the problem with updates, trigger or replication does not perform events on TARGET server (such as update, insert, delete ...) What can I do to make trigger work when update occur on TARGET? Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

Are you using Enterprise Replicateion? If so, then you must define the replicates with the "-T" option to cause trigger firing on the target instance. Otherwise you must define replicates on the table updated by the trigger. aannyy@my-deja.com wrote: > I have replication (Primary-Target) > > When updates at PRIMARY occur - TARGET server receives this updates > and updates its table - tab1, but trigger (on TARGET ) on this table > (CREATE TRIGGER TrName > UPDATE OF col1 ON tab1 > ..........) this trigger does not work when updates occur. > > But when I make updates on TARGET by myself - this trigger works! > > What is the problem with updates, trigger or > replication does not perform events on TARGET server (such as update, > insert, delete ...) > > What can I do to make trigger work when update occur on TARGET? > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.