"jay" <jaysql@hotmail.com> wrote in message
news:24aff01c38d0f$d8e6b510$a601280a@phx.gbl...
> just drop the subscriber in publication properties and
> make second one as publisher and create publications of
> this server, and make again firstone to push or second one
> as pull the subscriptions.
> >-----Original Message-----
> >Hi,
> > I need to setup replication for the following
> scenario. I could not
> >configure it as I required. Please suggest me what am I
> doing wrong.
> >
> >System specification
> >
> >Windows Server + MSDE 2000 in all publishers and
> subscribers
> >
> > I am having one main server which is configured as a
> publisher(TOP LEVEL).
> >Another publisher (MIDDLE LEVEL) will be there also
> configured. I need to
> >pull data from the TOP LEVEL publisher to MIDDLE LEVEL.
> But this step is
> >getting failed. [Error 21258 You must first drop all
> merge publications to
> >add an anonymous or local subscription to database 'xxx']
> At the same time
> >if I try to PUSH data from the TOP LEVEL to
> >MIDDLE LEVEL its working.
> > After this, I need to set up another level below this,
> means some
> >suscribers for this MIDDLE LEVEL publisher. In this case
> also, I need to
> >PULL data from the MIDDLE LEVEL publisher to BOTTOM LEVEL
> subscriber. Please
> >help me, Am I doing anything wrong??
> >
> >Regards,
> >
> >Krish
> >
> >
> >
> >
> >
> >.
> >