transactional replication

  • shreekanth.kavali

    Mr or Mrs. 500

    Points: 537

    After configure of transactional replication ,i want to add one more table ?will it be possible ,how will do that?

  • SQLAJ

    Ten Centuries

    Points: 1219

    You should be able to add a new table in the publishing database, make sure it is selected in the Publication Properties under the "Articles" page. If you have a test environment setup try it there first.

    ______________________________
    AJ Mendo | @SQLAJ

  • PRAMANA.DBA

    SSCertifiable

    Points: 5507

    EXEC sp_addarticle

    @publication = yourpublication_name,

    @article = Table_Name,

    @source_object = Table_Name

    go through below link, it will help to you .

    http://ansqldba.blogspot.in/2012/02/adding-new-article-to-existing.html

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply