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

SYMPTOMS

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.

RESOLUTION

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:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

WORKAROUND

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.