2

We have merge replication set up over a distributed environment (50 to 1500km between offices) for a SQL Server 2005 database of about 350Gb. We now need to add a couple of new tables that must also be in replication, but without pushing the new snapshot to all the subscribers. Is this possible, and if so, what would be the best way to go about doing this?

John Topley
  • 113,588
  • 46
  • 195
  • 237
Veldmuis
  • 4,678
  • 4
  • 25
  • 25

1 Answers1

1

sp_addmergearticle - Adds an article to an existing merge publication. This stored procedure is executed at the Publisher on the publication database.

http://msdn.microsoft.com/en-us/library/ms174329.aspx

Vendoran
  • 176
  • 6
  • Sorry but sp_addmergearticle will not work in this case if @force_reinit_subscription is set to false. Reinitialising replication is then mandatory. – Philippe Grondier Oct 23 '08 at 22:34