I have SQL 2005 with Transactional Replication of a 20GB Database.
What is the correct process for adding a new table to an existing Publication?
The reason I ask is that I have used sp_addarticle to add the new table to the existing Publication but it hasn't replicated to the subscriber.
How do I get it to replicate to the subscriber? Surely I don't have to perform another snapshot of the entire database again do I? We don't have time to replicate 20GB just for 1 new table!
View Complete Post