Microsoft KB Archive/945372

= The column of the rowversion data type is replicated to the subscriber after you synchronize the data between a SQL Server 2005 publisher and a SQL Server Compact 3.5 subscriber =

Article ID: 945372

Article Last Modified on 12/28/2007

-

APPLIES TO


 * Microsoft SQL Server Compact 3.5

-



SYMPTOMS
Consider the following scenario. You create a merge publication in Microsoft SQL Server 2005 to publish data to a SQL Server Compact 3.5 subscriber. You synchronize the data between the publisher and the subscriber. Then, you add a column of the rowversion data type to a table article in the publication. You synchronize the data again. In this scenario, the column of the rowversion data type is also replicated to the subscriber.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
A column of the rowversion data type contains values that are generated by the database engine. SQL Server 2005 Compact Edition does not support the rowversion data type. In SQL Server Compact 3.5, the support is added. If a table article from SQL Server 2005 does not contain a column of the rowversion data type when you create the publication, and then you add such a column later, the column will be replicated to SQL Server Compact 3.5 subscribers.

In a merge replication between SQL Server 2005 and SQL Server Compact 3.5, we do not support replicating a column of the rowversion data type. When you create a SQL Server 2005 publication for SQL Server Compact 3.5 and you filter a column of the rowversion data type out of a publication, the column will not be replicated to SQL Server Compact 3.5 subscribers. When you use the New Publication Wizard to create a publication to replicate a table article that contains a column of the rowversion data type in SQL Server 2005, SQL Server 2005 excludes the column in the publication. To make sure that a column of the rowversion data type is not included in a SQL Server 2005 publication for SQL Server Compact 3.5, use one of the following methods:
 * Use the New Publication Wizard in SQL Server 2005 to create a publication for SQL Server Compact 3.5.
 * Do not use the sp_addmergecolumn stored procedure to add a column of the rowversion data type in a SQL Server 2005 publication for SQL Server Compact 3.5.

In remote data access (RDA) between SQL Server 2005 and SQL Server Compact 3.5, we also do not support downloading or uploading the data from a column of the rowversion data type. To make sure that data from a column of the rowversion data type is not downloaded or uploaded, exclude the column from the SELECT statement that you specify in the Pull method.

Keywords: kbexpertiseadvanced kbtshoot kbprb KB945372

-

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

© Microsoft Corporation. All rights reserved.