sql server replication: If each publication has different tables/articles this is simple to set up.
If it has the same tables you must click on the browse button beside your
articles in the specify articles dialog of the create publication wizard.
Then click on the snapshot tab, then for the name conflicts group select
keep existing table intact or one of the delete options - which ever meets
your criteria.

Script out the tables in MSER, and run it on SER2. Then publisher the
tables in SER2 and make NEWSer a subscriber of SER2. Then send your snapshot
from MSER.

This is called republishing.

[quoted text, click to view]

I had asked the this question in here before, but i lost the answer, and
actually didnot understand the answer clearly.

I have a main server MSER as publisher. and 2 server SER1,SER2 as
subscriber. I want to install new server NEWSER.
NEWSER is a subscriber from SER2 while in the same time SER2 is subscriber
to MSER. how i can do that if am using the same database ?

Hi Samir,

Hilary is correct. You can search for "republish" in Books OnLine and get
additional information about this subject.


Regards,
Shirley
SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

I already do some research on the internet and read the BOL, at last i got
my answer but that after i got the idea from Hilary. Hilary idea was good
and i test in on demo database. it workes fine except the if replicate MSER
with SUB2 as snapshot, and SUB2 to NSER as merge, if the changes happend in
SUB2 or NEWSER the data is replicated between the 2 but not to MSER or i
missed something i didnot do. Any way I got the concept from Hilary Solution
and here is my Soultion :
While you are doing the replication at the MSER You have to go to Sync
Partners tab and check on "Allow Subscribtion to synchronize with other
partners than the publisher from which subscription was created." and then
select co-Prublisher from the list. but b4 you do that, you should configure
the second server as publisher also. and do the both replication as merge
replication.

Thanks to all who provide help.

[quoted text, click to view]