Tag: sp_MSrepl_addsubscription

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

I recently encountered this error when setting up Transactional Replication via SQL scripts. [crayon-5e86520d777ca480342786/] 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. Further in my script I see the call to sp_addsubscription.  From the BOL, this syntax look correct.  I’m
Read More »