Merge replication results are incorrect or merge replication fails when you try to use merge replication to merge SQL Server 2005 Mobile Edition data with SQL Server 2000 data (914792)

SYMPTOMS

When you try to use merge replication to merge Microsoft SQL Server 2005 Mobile Edition data with Microsoft SQL Server 2000 data, you may experience one of the following problems:

• The operation appears to be successful. However, the results are incorrect when you examine the subscriber table. You experience this problem when the data type of all the columns before the Identity column is the int data type or a data type that is compatible with the int data type.
• The merge replication fails, and you receive the following error message:
  The message received from the server cannot be decoded. Retry the operation. HRESULT 0x80004005 (29511)

This problem occurs when all the following conditions are true:

• The table has an Identity column.
• The Identity column is not the first column of the table.
• Merge replication involves both uploading changes and downloading changes for the table.
• The table is not empty after the synchronization process.

Note You do not experience this problem when the server that runs the publisher is running SQL Server 2005.