Specify all articles when subscribing to a publication using concurrent snapshot processing.

Share this Post

I recently encountered this error when setting up Transactional Replication via SQL scripts.

Msg 14100, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 533 
Specify all articles when subscribing to a publication using concurrent snapshot processing.

Looking at my create Publication script I see the default @sync_method = N’concurrent’ being set in sp_addpublication.  Nothing I want to change here.

image

Further in my script I see the call to sp_addsubscription.  From the BOL, this syntax look correct.  I’m running sp_addsubscription once for each article for this subscriber.

image

image

While the script looks correct, I wondered what the script would look like using default setting created by the Replication Wizard.  To test, I recreated the publication using the Wizard, then scripted out the publication.  I noticed Replication Wizard used had only 1 call to sp_addsubscription with option @article = N’all’.

image

Now the error makes sense.  When using Current Snapshot Processing I need to make 1 call to sp_addsubscription  with option and specify ALL articles for this subscriber.

Chris Skorlinski
Microsoft SQL Server Escalation Services


Share this Post

2 thoughts on “Specify all articles when subscribing to a publication using concurrent snapshot processing.”

  1. Hi Chris,

    Was there ever a root cause for why the output of say "Generate Scripts"  to produce the sp_addsubscription commands was defining @article = 'articlename' vs @article = 'all' when the publication is using concurrent snapshot processing?

    Was this a metadata issue? I'm experiencing this and hoping you have a lead.

    Thanks!

    Mike

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.