FIX: Updates to New Column Added to Merge Publication Article Are Not Replicated

Updates to a table used in a merge publication may not replicate if all the following conditions are met:

• The table is used in a merge publication and the initial snapshot has been applied at the Subscriber.
• The Merge Agent is running in Continuous mode.
• Rows have been replicated between the Publisher and the Subscriber.
• A new column is added to the table on the Publisher by using the sp_repladdcolumn stored procedure.
• After the new column has been replicated to the Subscriber, update the new column on the Publisher.

After the new column is updated on the Publisher, the next time the Merge Agent runs it indicates that updates have occurred. However, if you query the table on the Subscriber, the updates to the new column are not reflected.

To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

Unsubscribe to the publication before you add the new column on the Publisher. After the new column is added, subscribe to the publication again and reinitialize.

Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.

Stopping and restarting the Merge Agent does not resolve this problem.