Post reply

SQL2K Transactional Replication Help

  • May 9, 2002 at 8:40 am

    #78406

    We are using transactional replication and are running into a problem. Our system will often create tables "on the fly" in code, and we can't get the tables to replicate.

    Currently, we are issuing "CREATE TABLE" statements on the Publisher and Subscriber. Then, we are using the "sp_addArticle" stored proc to add the new article to the publisher.

    We can't get the data to replicate over for the new tables. Any ideas???

    thanks

    Corey

    MTFBWY...


    MTFBWY...

  • May 9, 2002 at 11:38 am

    #428821

    Seems like it would be easier to just create the table on the publisher, let the snapshot take care of the rest? Sp_addarticle should work - I recommend scripting out an existing pub you have a template for the syntax, just to be sure.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

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

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