"Vijay TS" wrote:

> 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