Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Bangalore, India
    Posts
    27

    Post Unanswered: Snapshot replication...

    When i recreate an article and try to run the snapshot replication i am getting the error as :-

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


    What is the reason for the same

    Thanks,
    Sandu

  2. #2
    Join Date
    Oct 2003
    Location
    Bangalore, India
    Posts
    27
    I got the solution for the above problem...


    Create Publication Wizard does not make concurrent snapshot processing the default when you create a transactional publication; however, if your application meets these criteria, it is recommended that you enable this option. To enable concurrent snapshot processing, change the snapshot generation mode. Open Publication Properties, click the Snapshot tab, and then select the Concurrent access during snapshot generation checkbox.

    Thanks,
    Sandu

Posting Permissions

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