FIX: MSDE SP1 Upgrade Does Not Update Merge Replication Components (306167)

The information in this article applies to:

Microsoft SQL Server 2000 Desktop Engine (MSDE) SP1

This article was previously published under Q306167

BUG #:355067 (SHILOH_BUGS)

SYMPTOMS

If you apply SQL Server 2000 Service Pack 1 (SP1) to a Microsoft Data Engine (MSDE) merge replication subscriber, and the subscription is reinitialized, the merge agent may fail with this error message:

Invalid column name 'maxversion_at_cleanup'

The preceding error message displays when subscriptions are reinitialized.

CAUSE

The Service Pack 1 upgrade for MSDE executes certain SQL scripts that update the server components. After these scripts execute, the next step is to execute the sp_vupgrade_replication stored procedure to update the replication-related objects. The SP1 setup fails to execute the sp_vupgrade_replication stored procedure, thereby not updating the replication system objects.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft 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

After the SP1 setup completes, execute the sp_vupgrade_replication stored procedure in the context of the master database of the MSDE subscriber. The sp_vupgrade_replication stored procedure iterates through all the databases that are being published and updates the relevant replication related system objects.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000 Service Pack 1. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.

Modification Type:	Major	Last Reviewed:	10/15/2002
Keywords:	kbBug kbDSupport kbSQLServ2000SP2Fix KB306167