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 2005 Forums
 SQL Server Administration (2005)
 automatically include new tables in replication

Author  Topic 

winanjaya
Starting Member

3 Posts

Posted - 2012-05-14 : 03:23:38
I am running Transactional replication on my SQL Server 2005, I have configured articles to be replicated on Remote host, currently, I have new tables, how to automatically include new table into replication process?..

any help would be greatly appreciated..

many thanks in advance

Regards
Winanjaya

tempdba
Starting Member

1 Post

Posted - 2012-05-16 : 05:41:27
You have to add the tables in the already existing replication using sp_addarticle, followed by adding subscription for the subscribers whom you want the table to be replicated to.
Go to Top of Page
   

- Advertisement -