mh,

Can you post the source link to your explanation? I am doubtful that while reinitialization everything is dropped/deleted and recreated.

So for a bidirectional(but always inserted at the subscriber) article, across publications, even if it is guaranteed that a uniquely identified row exists at only one subscriber (other than the...

I tried this:

exec sp_changepublication @publication = N'DBNAME',@property=N'replicate_ddl',@value=0, @force_reinit_subscription=1,@force_invalidate_snapshot=1

but it comes up with "Database is not enabled for publication". Now I know for sure that is not correct. There are...

Got it. Thank you very much.

Got It. Thank you! That's what the firewall guys did probably (fix 1433 as the port for R2), when we complained that sql server is not accessible on that port.

merge replication with pull subscribers

Thank you. So the answer is, If the user application (at subscriber side) is adding a row into the child table, the corresponding parent table MUST be present right?

EX: Products...

Just wanted to add a follow up. Order is not 'gauranteed' ofcourse, but as far as I know, it has no reason to bring back results out of order than...

Thank you all for the replies. I know order is not gauranteed, but I just have never seen order changing based on the value in where clause.

eg: .... where col...

I ended up hacking what I wanted from here:

http://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-text-files/

Great! Thanks..

Excellent!! Thank you so much for the solution.