Article ID: 324563 - View products that this article applies to.
This article was previously published under Q324563
If a publication that has Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) subscribers is marked for reinitialization at the publishing server, the SQL Server CE subscribers may experience data loss and non-convergence, or both, if the following conditions are satisfied:
The merge replication reconciler is sending incorrect information to the SQL Server CE subscriber. SQL Server CE uses the incorrect information to initialize one of the merge replication system tables on the SQL Server CE device. The incorrect value causes the SQL Server CE subscriber to skip the changes instead of enumerating and uploading the changes to the publisher.
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:
290211NOTE: The following hotfix was created before the release of Microsoft SQL Server 2000 Service Pack 3.
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How To Obtain the Latest SQL Server 2000 Service Pack
The English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Note Because of file dependencies, the most recent hotfix or feature that contains the files may also contain additional files.
Date Time Version Size File name ---------------------------------------------------------------- 06-14-2002 9:39:16 PM 8.00.645 303,688 bytes Replrec.dll
To work around this problem, you can use either of these two methods:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.