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)
 Adding new tables to publication

Author  Topic 

venkath
Posting Yak Master

202 Posts

Posted - 2007-06-25 : 11:22:30
How to add new tables to existing Transactional replication

We have two databases in the same server
Transactional replication is already setup
Snapshot agent runs every one hour

Can some one guide me the steps to do it..

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-25 : 12:53:17
Drop the subscription, add the article to the publication, re-add the subscription.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -