Post reply

Cannot add article back into Publication

  • April 28, 2009 at 4:41 am

    #99618

    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:

    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.

  • April 28, 2009 at 6:31 am

    #985015

    I know this seems crazy and apologies if you have already tried this but in the call to sp_addsubscription change @article = 'nbdocdeletedrecords' to @article = 'all'. I haven't got any SQL Server 2000 servers left to try it out on so apologies if I'm wasting your time.

    Mike

  • April 28, 2009 at 8:00 am

    #985110

    Thank you. I read on another forum that if you leave out the '@article ' line it defaults to all.

    I ran it like this and it worked!! Thank you so much for your help

    exec sp_addsubscription @publication = 'TowerDB to KOCSQl03'

    -- , @article = 'nbdocdeletedrecords'

    , @subscriber = 'KOCSQL03'

    , @destination_db = 'TOWERDB'

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

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