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 2008 Forums
 Replication (2008)
 adding a table

Author  Topic 

AgaK
Yak Posting Veteran

86 Posts

Posted - 2011-04-08 : 17:07:32
Hi,

Is it possible to add a table to the publication and then subscription without initializing the replication?

Thanks

AK

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2011-04-08 : 19:50:33
yes... check out sp_Addarticle

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

AgaK
Yak Posting Veteran

86 Posts

Posted - 2011-04-11 : 18:55:32
Thank you for your reply. sp_Addarticle adds articles to the publication. Is it possible to add an article to the subscription without initializing the replication?

thanks
AK
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-04-21 : 01:20:27
No . u have to reinitialse the sub
Go to Top of Page
   

- Advertisement -