December 4, 2002 at 6:25 am
Hi,
I am using the replicatiion on the sql 7 server. I have a publication as well as scbscription configured. At the time of creation of publication i added the articles. When the snapshot starts the articles get published in the subscription db.
But what i want now is, when I adds new table(any object) in the db which is releated to publication then it does not get published in the subscribed table, untile i adds the article in the publication manually.
Waht should i do if i want it automatically?
Waiting for the quick replies
Prakash
December 4, 2002 at 7:14 am
You have to remove the sbuscribers to add an article. A simple alternative is to just create a new pub for your new table.
Andy
December 4, 2002 at 8:26 am
Hi
thanks for immediate reply
But I don't want to add the article manually. It should happen automatically
Is there is another way
Prakash
December 4, 2002 at 1:43 pm
Not that I know of. You could build a job that checks for tables not included and does the work for you.
Andy
December 4, 2002 at 1:51 pm
No not to an existing publication. Must drop and recreate or create a new seperate publication.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply