I am trying to set up Multiple Publications into single subscriber
database using merger replication, I have done so in the past using
Transactional using Row filters and making sure that not both of them
drop the tables on reinitialization. However i'm now tring to do this
with merge for another project as i need the subscriber to be able to
update the table too.


However this isn't proving easy or even possible. This form of
replication puts triggers on the subsciber's tables, and as my
publishers are not both creating the table, only one gets the triggers
it wants. Is what i am doing possible, will i have to write my own
triggers?


FYI the problem i'm getting is on the merging of data from the
publisher that was set up second publisher, i get conficts that are not
resolved.


Conflict Type 10
Reason Code 2
The row was updated at 'publisher' but could not be updated at
'subscriber'. Unable to synchronize the row because the row was updated

by a different process outside of replication.

I could be missing something here, but it looks like you have multiple
publications/publishers publishing to the same subscribing table.

You need to look at your topology to somehow configure a single
publisher with one or more publications, but with each table going to a
single table on the subcription database. So if you were publishing the
pubs database, you could have 20 publications, authors could be in each
publication, but only one publication could be subscribed to by the
northwinds database.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Correct, I do have two publication/publisers going to one subscriber
that is what i'm after and as i said i already do this with
transactional replication.

Sorry for the confusion
e.g.
DataBase1
Table1
PrimaryID Identity(1,2)

DataBase2
Table3
PrimaryID Identity(2,2)

Publish from Table1 from DataBase1with a row filter of PrimaryID % 2 =
1 to Table3 in Database 3
Publish from Table2 from DataBase2with a row filter of PrimaryID % 2 =
0 to Table3 in Database 3

And set the Articles to not drop the tables, rather delete all data
depending on the row filters