Issue when my Merge Publisher DB is Subscriber for Trans Replicati

Hi,
I have Database which is configured as a Merge Publisher , This database
has 3 Tables Employee,Dept and Country. All these 3 tables are repliated to
another database for high availability purpose using Merger Replication.
The Merge Publisher is also an Subscriber for another Transactional
Publication, where in only Country Table is being pulled.
My issue is When i add a new record in for a new country in the
Transactional Pulisher the data gets populated to my Merge Publisher but it
dosent get pushed to the Merge Subscriber automatically, i have to explisitly
run sp_addtabletocontents for the country table to get the new record pushed
to Merge Subscriber.
This has become an additional overhead , due to this am never sure that both
Merge Publisher and Subscriber have exact data.
Can some one provide the solution for this.
Regards
Pradeep
Please verify if the @.published_in_tran_pub bit is set for the articles
you can take a look at the sysmergearticles table for it
If you can enable it by specifying @.published_in_tran_pub='true' using
sp-addmergeartice or sp_changemergearticle
“This posting is provided "AS IS" with no warranties, and confers no rights.”
"PRADEEP M.M." wrote:

> Hi,
> I have Database which is configured as a Merge Publisher , This database
> has 3 Tables Employee,Dept and Country. All these 3 tables are repliated to
> another database for high availability purpose using Merger Replication.
> The Merge Publisher is also an Subscriber for another Transactional
> Publication, where in only Country Table is being pulled.
> My issue is When i add a new record in for a new country in the
> Transactional Pulisher the data gets populated to my Merge Publisher but it
> dosent get pushed to the Merge Subscriber automatically, i have to explisitly
> run sp_addtabletocontents for the country table to get the new record pushed
> to Merge Subscriber.
> This has become an additional overhead , due to this am never sure that both
> Merge Publisher and Subscriber have exact data.
> Can some one provide the solution for this.
> Regards
> Pradeep