Add article in replication

• stephane1747

  Grasshopper

  Points: 13

  More actions

  January 24, 2007 at 2:54 am

  #90884

  I have problem when i add one article in a transactional replication

  I have run

  exec sp_addarticle @publication = 'Company'

  , @article = 'TBApplications'

  , @source_table = 'TBApplications'

  exec sp_addsubscription @publication = 'PBCompany'

      , @article =  'TBApplications'

      , @subscriber =  'server2'

   

  But modification in article are not replicated...

  Can help me?

  Thanks

• Chris Becker

  SSCrazy

  Points: 2585

  More actions

  January 25, 2007 at 7:06 am

  #685513

  Did you start your snapshot agent? I leave my snapshot agent on a nightly schedule just in case I forget to start manually when adding articles...

  Regards,

  Chris B.  MCDBA MCSE OCP

  http://www.MSSQLConsulting.com

   

   

  Chris Becker bcsdata.net