Microsoft KB Archive/306167

= FIX: MSDE SP1 Upgrade Does Not Update Merge Replication Components =

Article ID: 306167

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft SQL Server 2000 Desktop Engine

-



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.

Additional query words: sp1

Keywords: kbbug kbfix KB306167

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.