Hi,

I am making of sql 2005 - transaction replicaton.

data flows from the publisher to the subscriber - staging tables. From the
staging tables we want the data to move to the transaction tables at the
subscriber end.

We are moving the data to the transaction table by having triggers in the
staging tables.

say tblx from publisher will move to tblStgX in the subscriber. then we have
some trigger in tblStgX , which ports it to tblX in the subscriber end.

but these triggers are not getting fired the first time when the
subscription is set up (when data is read from the initial snapshot).  how
can i trun this trigger on? any help

pls. tell me if the approach is rite, or u have any other suggestion to this.

thnks in advance

--anu