Post reply

Adding an article to transactional replication

  • October 1, 2012 at 9:51 am

    #265112

    I have Transactional replication running on a SQL Server 2000 Server with a push type replication to one subscriber.

    I am trying to add a new tables (article) to the Subscription

    I ran the following (against the Publishing Database)

    exec sp_dropsubscription ...

    ---/*

    exec sp_droparticle ...

    ---/*

    exec sp_addarticle ...

    ---/*

    exec sp_addsubscription ...

    ---/*

    -EXEC sp_refreshsubscriptions

    @publication = N'TestDB'

    Then I run SNAPSHOT on the Publisher and I get a message saying: "A snapshot was not generated because no subscriptions needed initialization." ??

  • October 1, 2012 at 1:15 pm

    #1544109

    if anyone is interested. I changed the @sync_type = parameter in the sp_addsubscription command from @sync_type = N'none', to @sync_type = N'automatic', and Snapshot is picking up the changes now.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply