How to add new table during Replication

• su_kumar11

  SSCommitted

  Points: 1675

  More actions

  August 12, 2008 at 12:40 am

  #190905

  Hi,

  Can any one tell me how to transfer a new table during replication

  when we have all ready configured for replication on other server?

  Pls help me out as possible as...

  regards

  Sunil..............

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  August 12, 2008 at 12:49 am

  #856509

  You can add a new table to an exisiting publication using the stored procedure sp_addarticle. See BOL for details.

  [font="Verdana"]Markus Bohse[/font]

• su_kumar11

  SSCommitted

  Points: 1675

  More actions

  August 12, 2008 at 12:55 am

  #856512

  Hi,

  Can you tell me in details..........

  Regards

  Sunil....

  MCTS

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  August 12, 2008 at 3:45 am

  #856555

  As I wrote before look in Books Online and you will find all the details. As an alternative see http://support.microsoft.com/kb/830210

  [font="Verdana"]Markus Bohse[/font]

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  August 12, 2008 at 4:48 am

  #856573

  hi Markus Bohse,

  Can u please send me note for MCDBA paper .i m desperate to give exam...but i m not getting notes..

  Pleaseeeeeeeeeeeeeee..help mee

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)