• I could not get it to work through using the GUI. It would still prompt that a snapshot was needed. However, I was able to script it. I did have to make @pre_creation_cmd = 'none', but I also had to run the command sp_addsubscription with @sync_type = 'replication support only'. Here are the scripts with generic names.

    USE [PublicationDB]

    EXEC sp_addarticle @publication = N'Publication', @article = N'Table', @source_owner = N'dbo',

    @source_object = N'Table', @type = N'logbased', @description = N'', @creation_script = N'',

    @pre_creation_cmd = N'none', @schema_option = 0x000000000803509F, @identityrangemanagementoption = N'manual',

    @destination_table = N'Table', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false',

    @ins_cmd = N'CALL [dbo].[sp_MSins_Table]', @del_cmd = N'CALL [dbo].[sp_MSdel_Table]',

    @upd_cmd = N'SCALL [dbo].[sp_MSupd_Table]'

    GO

    USE [PublicationDB]

    EXEC sp_addsubscription @publication = N'Publication', @subscriber = N'Subscriber',

    @destination_db = N'SubscriberDB', @subscription_type = N'Push', @sync_type = N'replication support only',

    @article = N'Table', @update_mode = N'read only', @subscriber_type = 0