Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: cannot add article back into publication

    MS SQL Server 2000 SP4

    I have one Database that I replicate. The log reader is always running I the REPL push job runs every 15 mins. This works good for us.

    I had to change the column length on one field in a replicated table and here is the SQL I used:


    Code:
    exec sp_dropsubscription @publication = 'TowerDB to KOCSQl03'
    , @article = 'nbdocdeletedrecords'
    , @subscriber = 'KOCSQL03'
    , @destination_db = 'TOWERDB'
    exec sp_droparticle @publication = 'TowerDB to KOCSQl03'
    , @article = 'nbdocdeletedrecords'
    alter table tower.nbdocdeletedrecords alter column memfnam varchar(35) null
    exec sp_addarticle @publication = 'TowerDB to KOCSQl03'
    , @article = 'nbdocdeletedrecords'
    , @source_table = 'tower.nbdocdeletedrecords'
    exec sp_addsubscription @publication = 'TowerDB to KOCSQl03'
    , @article = 'nbdocdeletedrecords'
    , @subscriber = 'KOCSQL03'
    , @destination_db = 'TOWERDB'
    Problem is... when I got to the last step "exec sp_addsubscription...."
    I got this error: Can anyone help me out??????

    Server: Msg 14100, Level 16, State 1, Procedure sp_addsubscription, Line 240
    Specify all articles when subscribing to a publication using concurrent snapshot processing.

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Your first exec droppped the entire subscription from TOWERDB, not just an article within that subscription.

    Try executing your last exec without the @article argument. It defaults to all (for all articles within that publication).

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Dec 2007
    Posts
    288
    awesome. Thank you. I tried this and it worked:

    exec sp_addsubscription @publication = 'TowerDB to KOCSQl03'
    -- , @article = 'nbdocdeletedrecords'
    , @subscriber = 'KOCSQL03'
    , @destination_db = 'TOWERDB'

Posting Permissions

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