Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Publishing Articles for Merge Replication

Author  Topic 

debug
Starting Member

29 Posts

Posted - 2003-08-13 : 23:54:52
HI,

Just wanted to know that what is the way to pulish articles for Merge replication once the publication has been set and pushed to subscriber, apart from recreating hte publication and pushing it again.

Regards,
DU



DU

samrat
Yak Posting Veteran

94 Posts

Posted - 2003-08-14 : 00:45:39
USE sp_addarticle, to publish article once the publication is created and subscriptions are pushed.

Refer to BOL for complete syntax on sp_addarticle

HTH,

Samrat
Go to Top of Page

debug
Starting Member

29 Posts

Posted - 2003-08-14 : 16:26:21
hi,

Thanks for the prompt response....

I tested out publishing an article which was a table in my currently set up publication through sp_addmergearticle but unfortunately it only allows table.article i.e. table.column to be published.

sp_addarticle does not work for Merge replication.

My question is that is there any way in which we can add a whole table as an article to an existing publication ??

REgards,
DU

DU
Go to Top of Page
   

- Advertisement -