adding articles in publication

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  October 29, 2013 at 3:59 am

  #279319

  how to add the articles in transactional replication ?expalion in detail

• RTaylor2208

  SSChampion

  Points: 13298

  More actions

  October 29, 2013 at 4:13 am

  #1662267

  In my experience, you can either add the artciles via the gui in SSMS or use the system stored procedures to add the article(s) to the publication

  Once added this will invalidate your snapshot and also it will not replicate the new articles in the publication.

  Run the snapshop and reinitialse the subscriptions via replication monitor or using the SQL Agent Jobs \ system stored procedures.

  MCITP SQL 2005, MCSA SQL 2012