Please elaborate on what exactly you are trying to do and what does this have to do with Replication!

If you only have 1 Publication, then how can you replicate different Articles to 2 Subscribers?

Merge Replication will automatically add a rowguid column for each table that will participate in a Publication. You will have to range the Identity columns.

Yes! I have seen this before. It's because you tried to remove replication inappropriately or you truied to restore the Database when it was marked for replication. What you have...

Create the Initial snapshot to a Database in Head Office, then burn it to disk, ship it out to region, attach Database then configure Subscriber from Head Office.

Articles belong to a Publication, Did you create 2 Publications, 1 for each Subscriber? If each Subscriber is suppose to have different Articles, then you need to creat 2 seperate...

You have to redo the publication! You have no choice!

You will have to create a seperate process to update the main table. I would not use a trigger on a replicated table!

Click the Advanced tab within the step and there is an option there for an output file. Success and/or failures will be recorded in this file.

Do you get an error message?

Thanks to the both of you, I will give it a go. Seems like XML is still in its infantry stages as there are no decent tools for XML.

Have a look at the -h parameter in BOL for BCP.

Go to http://www.microsoft.com/sql

There you will find white papers.

Boban Jayan,

Make sure you have enough disk space on the subscription server!

Maqs,

Thanks for all that info. I modified  acouple of tags in the XSD schema and the SQLXMLBulkLoad works. That xsd utility is awsome!

Talk to you later.