Hi Roy,

Yes, you can create like that but without re-initialising the subscription/running the snapshot again, data from internal to external databases does not get pushed at all.

Hi noeld

Yes, I had missed to set that option. Have done it which did the magic. (default option in sql server 2005 is to drop the table before re-synchronising.) - Thanks