Hi,
In SQL SERVER 2008 R2 Transactional Replication, how to add new table & data into existing subscription.
already Transactional publication configured in primary database server, after that new table was created on same database. this table how to move subscription database server?
I tried as below command, but it is not hope.
EXEC sp_addsubscription
@publication = 'TransRep_Publication',
@article = 'dbo.newtablename',
@subscriber = 'servername',
@destination_db = 'TransRep',
@reserved='Internal'
Msg 20027, Level 11, State 1, Procedure sp_MSrepl_addsubscription_article, Line 123
The article 'dbo.testdata' does not exist.
thanks
ananda