Adding Article to Transactional Replication Without Creating Entire Snapshot

To add new article, follow below steps.


1) Add article using the below script in the publisher server.
        sp_addarticle @publication='Test_Tran',    
        @article='dbo.Table_4',@source_object='Table_4',
        @force_invalidate_snapshot=1



2) Run the below script in publishing DB
       EXEC sp_changepublication  @publication = 'Test_Tran',
         @property = N'allow_anonymous', @value = 'false'

       GO
       EXEC sp_changepublication @publication = 'Test_Tran',
       @property = N'immediate_sync', @value = 'false'
       GO



3) Start the SnapShot Agent. This time only the newly generated article will be    
    initialized.