Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Replication question

Author  Topic  LianaS Starting Member 6 Posts Posted - 2003-07-07 : 03:12:19 Hello everybody! I have a database that has some tables replicated in another database. I am using transactional replication and no updates are made at the subscriber. I need to do the following: 1. To add columns in a table that is being replicated, and to allow these columns to be seen at the actual subscriber. 2. Add a table to the publisher and make it visible at the actual subscriber. The subscriber uses a pull subscription. For the first problem I tried to alter the table by using sp_repladdcolumn. The new column is also created in the subscriber table, but the values for that new column do not arrive at the subscriber except for the INSERT (when I update the newly added column, the value is not propagated at the subscriber). For the second problem I added the table at the publisher , at the subscriber and I used sp_addarticle to publish the table. But the values do not arrive at the subscriber, and when I inspect the Subscriptions tab in the Properties of the publication, I see that the value for "All articles" is not "all" but "some". The only solution that I found was to remove the subscription, do all the changes at the publisher and at the subscription database also (alter the table to add the columns and create the new table) and than recreate the subscription. Since the two databases are synchronized, I don't find necessary to send the snapshot to the subscription. Could you please help me and tell me what steps should I follow when I want to add columns to an article and to add a new article at the subscriber. I'm not sure that my solution is the good one, or if there is another way to do it. I don't understand also why when I add a column with sp_addcolumn, the updates do not arrive at the subscription for that column, but the inserts arrive. Thank you all very much.