• Seems about right but would strongly encourage you to verify that the anonymous/immediate_sync options have been set properly, if they are not set to 0, when you trigger the snapshot...it will create snapshots for all articles (not just the two you want).

    You can check this by running /* On the distributor run to verify the publishers - make CERTAIN allow anonymous/immediate_sync are all ZEROS */

    SELECT publisher_id, publication_id,

    publisher_db ,

    publication , allow_anonymous, immediate_sync

    FROM distribution. dbo.MSpublications WHERE publication_type = 0 --> 0 for transactional, 1 for snapshot

    /* If IMMEDIATE_SYNC is not zero, run the following on the ditributor */

    EXEC sp_changepublication @publication = 'YourPub', @property = 'allow_anonymous', @value = 'false'

    GO

    EXEC sp_changepublication @publication = 'YourPub', @property = 'immediate_sync', @value = 'false'

    GO

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience