Incorrect sort order for a subscriber in SQL Server Compact 3.5 SP2 that synchronizes with a publisher in SQL Server

Article translations Article translations
Article ID: 2637556
Expand all | Collapse all

SYMPTOMS

Consider the following scenario:
  • You create a subscriber in SQL Server Compact 3.5 Service Pack 2 (SP2), and then synchronize the subscriber with a publisher that is in SQL Server.
  • You create an index that contains a multicolumn index that has a defined sort order for an article of the publication. For example, you create the index by using the following statement:
    CREATE INDEX index_name on table_name ([Column1] ASC, [Column2] DESC)
In this scenario, the sort order of the second column is incorrect after the index creation statement in the .out file is sent during synchronization. Additionally, after SQL Server Compact 3.5 downloads the snapshot during initialization of the replication process, the database table of the subscriber does not specify an index sort order in the INFORMATION.SCHEMA.INDEXES view.  

RESOLUTION

The hotfix that resolves this issue is included in cumulative update package 7 for SQL Server Compact 3.5 SP2. 

For more information about how to obtain cumulative update package 7 for SQL Server Compact 3.5 SP2, click the following article number to view the article in the Microsoft Knowledge Base: 
2553608 Cumulative Update 7 for SQL Server Compact 3.5 Service Pack 2

WORKAROUND

To work around this issue, manually create an index with a defined sort order on the subscriber database after the data is downloaded from the publisher.

MORE INFORMATION

For more information about the CREATE TABLE statement, visit the following MSDN website:
General information about the CREATE TABLE statement
For more information about the CREATE TABLE statement in SQL Server Compact, visit the following Microsoft website:
General information about the CREATE TABLE statement in SQL Server Compact


Properties

Article ID: 2637556 - Last Review: January 20, 2012 - Revision: 2.0
Keywords: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew KB2637556

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com