can a Subscriber server be a Publisher server?

[Samir R. Ibrahim]

I have Main server as Publisher "MSER", 2 other server as subsriber
"SUBSER1","SUBSER2", I want to add another server "NEWSER" as subscriber but
the data must came from SUBSER2 using the same database.

NEWSER is a subscriber in SUBSER2, SUBSER2 is subscriber in MSER. can that
be done? if yes i want a little help on how to do it.

Thanks in advance.

[Danny Mansour]

Hi there,

Yes, this can be done. Please search for "Republisher"
subject in Books OnLine. But basically configure SUBSER2
as a publisher as you did with MSER, but the most
important is when you create the subscription for SUBSER2
to subscribe from MSER, you have to set the Subscription
Priority to the second option on the Set Subscription
Priority' wizard page. The option is "Use the following
priority, between zero (lowest) and 99.99 (highest), to
resolve the conflict". You might have to drop the
existing subscription and restablish it if you have not
chosen this option when creating the subscription.
Then proceed as normal by creating a publication for the
database on SUBSER2 and subscribe to it from NEWSER.

I hope this helps.
Thanks,
Danny

>.
>