Incorrect sort order for a subscriber in SQL Server Compact 3.5 SP2 that synchronizes with a publisher in SQL Server
- 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)
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:
CREATE TABLE statement in SQL Server Compact, visit the following Microsoft website:
Article ID: 2637556 - Last Review: 01/20/2012 08:27:00 - Revision: 2.0
- kbqfe kbfix kbexpertiseadvanced kbsurveynew KB2637556