3 removed reference to irrelevant unsupported variable from 2008
source | link

I am trying to add new articles to an existing publication in SQL Server 2012.

I am adding the article to the publication with the syntax

--add the table into the correct publication
sp_addarticle @publication='<publicationname>', @article='CardBookingType_tbl', @source_object='CardBookingType_tbl'

Previously on SQL Server 2008 I used to use the following syntax to subscribe to 1 table only and then run the snapshot. This no longers work on SQL 2012 as you have to subscribe to all articles.

--add the table into the subscription
EXEC sp_addsubscription
        @publication = '<publicationname>',
        @article = 'CardBookingType_tbl',
        @subscriber = '<Servername>',
        @destination_db = '<dbname>',
        @reserved='Internal'
GO

In SQL Server 2012, if I add the table via the GUI and then run the snapshot agent it picks up the new table fine. But if I add via the script it appears in the gui but the snapshot reports no new items were detected.

Seems like I am missing a piece of code to flag the subscribers as missing a article?

I am trying to add new articles to an existing publication in SQL Server 2012.

I am adding the article to the publication with the syntax

--add the table into the correct publication
sp_addarticle @publication='<publicationname>', @article='CardBookingType_tbl', @source_object='CardBookingType_tbl'

Previously on SQL Server 2008 I used to use the following syntax to subscribe to 1 table only and then run the snapshot. This no longers work on SQL 2012 as you have to subscribe to all articles.

--add the table into the subscription
EXEC sp_addsubscription
        @publication = '<publicationname>',
        @article = 'CardBookingType_tbl',
        @subscriber = '<Servername>',
        @destination_db = '<dbname>',
        @reserved='Internal'
GO

In SQL Server 2012, if I add the table via the GUI and then run the snapshot agent it picks up the new table fine. But if I add via the script it appears in the gui but the snapshot reports no new items were detected.

Seems like I am missing a piece of code to flag the subscribers as missing a article?

I am trying to add new articles to an existing publication in SQL Server 2012.

I am adding the article to the publication with the syntax

--add the table into the correct publication
sp_addarticle @publication='<publicationname>', @article='CardBookingType_tbl', @source_object='CardBookingType_tbl'

Previously on SQL Server 2008 I used to use the following syntax to subscribe to 1 table only and then run the snapshot. This no longers work on SQL 2012 as you have to subscribe to all articles.

--add the table into the subscription
EXEC sp_addsubscription
        @publication = '<publicationname>',
        @subscriber = '<Servername>',
        @destination_db = '<dbname>'

GO

In SQL Server 2012, if I add the table via the GUI and then run the snapshot agent it picks up the new table fine. But if I add via the script it appears in the gui but the snapshot reports no new items were detected.

Seems like I am missing a piece of code to flag the subscribers as missing a article?

2 added 80 characters in body; edited title
source | link

Snapshot not picking up new articles in SQL serverServer 2012 transaction replictionreplication when added through script

I am trying to add new articles to an existing publication in SQL Server 2012.

I am adding the article to the publication with the syntax

    --add the table into the correct publication
    sp_addarticle @publication='<publicationname>', @article='CardBookingType_tbl', @source_object='CardBookingType_tbl'

previouslyPreviously on SQL Server 2008 I used to use the following syntax to subscribe to 1 table only and then run the snapshot. This no longers work on SQL 2012 as you have to subscribe to all articles.

    --add the table into the subscription
EXEC sp_addsubscription
   EXEC sp_addsubscription
    @publication = '<publicationname>',
        @article = 'CardBookingType_tbl',
        @subscriber = '<Servername>',
        @destination_db = '<dbname>',
    @reserved='Internal'
    @reserved='Internal'
GO

In SQL Server 2012, Ifif I add the table via the GUI and then run the snapshot agent it picks up the new table fine. butBut if I add via the script it appears in the gui but the snapshot reports no new items were detected.

seemsSeems like I am missing a piece of code to flag the subscribers as missing a article?

Snapshot not picking up new articles in SQL server 2012 transaction repliction when added through script

I am trying to add new articles to an existing publication in SQL Server 2012.

I am adding the article to the publication with the syntax

    --add the table into the correct publication
    sp_addarticle @publication='<publicationname>', @article='CardBookingType_tbl', @source_object='CardBookingType_tbl'

previously on 2008 I used to use the following syntax to subscribe to 1 table only and then run the snapshot. This no longers work on SQL 2012 as you have to subscribe to all articles.

    --add the table into the subscription
    EXEC sp_addsubscription
    @publication = '<publicationname>',
    @article = 'CardBookingType_tbl',
    @subscriber = '<Servername>',
    @destination_db = '<dbname>',
    @reserved='Internal'
    GO

In 2012, If I add the table via the GUI and then run the snapshot agent it picks up the new table fine. but if I add via the script it appears in the gui but the snapshot reports no new items were detected.

seems like I am missing a piece of code to flag the subscribers as missing a article?

Snapshot not picking up new articles in SQL Server 2012 transaction replication when added through script

I am trying to add new articles to an existing publication in SQL Server 2012.

I am adding the article to the publication with the syntax

--add the table into the correct publication
sp_addarticle @publication='<publicationname>', @article='CardBookingType_tbl', @source_object='CardBookingType_tbl'

Previously on SQL Server 2008 I used to use the following syntax to subscribe to 1 table only and then run the snapshot. This no longers work on SQL 2012 as you have to subscribe to all articles.

--add the table into the subscription
EXEC sp_addsubscription
        @publication = '<publicationname>',
        @article = 'CardBookingType_tbl',
        @subscriber = '<Servername>',
        @destination_db = '<dbname>',
        @reserved='Internal'
GO

In SQL Server 2012, if I add the table via the GUI and then run the snapshot agent it picks up the new table fine. But if I add via the script it appears in the gui but the snapshot reports no new items were detected.

Seems like I am missing a piece of code to flag the subscribers as missing a article?

1
source | link

Snapshot not picking up new articles in SQL server 2012 transaction repliction when added through script

I am trying to add new articles to an existing publication in SQL Server 2012.

I am adding the article to the publication with the syntax

    --add the table into the correct publication
    sp_addarticle @publication='<publicationname>', @article='CardBookingType_tbl', @source_object='CardBookingType_tbl'

previously on 2008 I used to use the following syntax to subscribe to 1 table only and then run the snapshot. This no longers work on SQL 2012 as you have to subscribe to all articles.

    --add the table into the subscription
    EXEC sp_addsubscription
    @publication = '<publicationname>',
    @article = 'CardBookingType_tbl',
    @subscriber = '<Servername>',
    @destination_db = '<dbname>',
    @reserved='Internal'
    GO

In 2012, If I add the table via the GUI and then run the snapshot agent it picks up the new table fine. but if I add via the script it appears in the gui but the snapshot reports no new items were detected.

seems like I am missing a piece of code to flag the subscribers as missing a article?