How to stop Tranactional Replication in sql server 2005

• solomon.jernas

  Hall of Fame

  Points: 3680

  More actions

  October 12, 2012 at 4:48 am

  #283015

  In Business purpose we need to stop replication for 3 hours, after that enable the replication. Then

  How to add table and new field in existing publication? what are the steps follows

  Please help me anyone ?

  Thanks

  Jerry

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  October 12, 2012 at 6:05 am

  #1548575

  You can use sp_dropsubscription and then add article when required and then refresh subscritpion to reenable.