• I followed the steps at this link "http://www.mssqltips.com/sqlservertip/2502/limit-snapshot-size-when-adding-new-article-to-sql-server-replication/"

    which only by coincidence seems to be by a previous poster on this thread.

    The steps are similar to those steps DEVDB highlights but does not include the

    exec sp_refreshsubscriptions 'publication' step.

    It seems the if you add a new article via the GUI this step is not needed - but the end result is the same (also some of DEVDB's example code is deprecated)

    A question: If setting "'allow_anonymous" and "immediate_sync" allows only the new article to be replicated instead of the entire snapshot. Then why would these settings "FALSE" not be the default?

    I would have thought this would be the preferred option for most users.

    thanks