• Simon Liddle - Friday, August 31, 2007 4:32 AM

    Hi,(SQL2k pub, SQL2k dist, SQL7 subs)I used Enterprise Manager's Generate Script option on one of my publications and noticed that when creating the subscriptions, for most of the subscribers, the script generates: sp_addsubscription .... @article = N'all' ....However, for one of the subscribers, there are a number of statements, each specifying one of the articles in the publication but ultimately making a subscription to the same articles as the other subscribers, i.e. all of them: sp_addsubscription .... @article = N'supplier' ..... sp_addsubscription .... @article = N'customer' ..... sp_addsubscription .... @article = N'user' .....Is there any difference between these two ways of subscribing to all articles? Is one way 'better' than the other? Thanks!Simon

    I know this is an old post, but the issue still remains.

    When you script out and see each article added separately, that means that that subscriber was created without the @articles = "all" option and/or that an individual article was removed from the sub after creation.  If you usually subscribe to all articles, this is actually a good way to detect errors!