Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Bermuda
    Posts
    40

    Unanswered: Snapshot Replication - Adding articles

    Hey All - Another replication question:

    Using VBScript in an ActiveX module of a DTS package...

    Anyone have an idea how to add ALL articles to a Subscription.

    The only way I can figure it is to load an array from sysobjects, then run sp_addarticle on each one.

    Thanks for your help

    RobbieD
    Sunny Times...

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    In the sp_add_subscription call, use "all" as the article.

    -PatP

  3. #3
    Join Date
    Jan 2004
    Location
    Bermuda
    Posts
    40
    Thanks Pat.

    I'll give it a go.

    Robbie
    Sunny Times...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •