Cumulative update package 7 for SQL Server Compact 3.5 Service Pack 2 contains hotfixes for issues that were fixed after the release of Microsoft SQL Server Compact 3.5 Service Pack 2 (SP2).
Note This is build 3.5.8089.00 of the cumulative update package.
We recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new update release contains all the hotfixes and all the security updates that were included with the previous SQL Server Compact 3.5 update release. We recommend that you consider applying the most recent update release.
How to obtain this cumulative update package
A supported cumulative update package is now available from Microsoft. However, this update package is intended to correct only the problems that are described in this article. Apply this cumulative update package only to computers that are experiencing these problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server Compact 3.5 service pack that contains the hotfixes in this cumulative update package.
If the cumulative update package is available for download, the top of this Knowledge Base article has a "Hotfix download available" section. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.
Note If additional issues occur or if any troubleshooting is required, you may have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft website:
Incorrect sort order for a subscriber in SQL Server Compact 3.5 SP2 which synchronizes with a publisher in SQL Server
Cumulative update package information
There are no prerequisites for installing this cumulative update package.
You may have to restart the computer after you apply this cumulative update package.
To use one of the hotfixes in this package, you do not have to make any changes to the registry.
Packages that are included
This cumulative update package includes the following packages:
The Windows Installer files for the 32-bit version of the desktop runtime and for the 64-bit version of the desktop runtime
To install the Windows Installer files for the 64-bit version of the desktop runtime, you must first install the Windows Installer files for the 32-bit version of the desktop runtime. If you perform a Build to build upgrade, you still must first install the Windows Installer files for the 32-bit version of the desktop runtime.
SQL Server Compact 3.5 SP2functions correctly only if the 64-bit and 32-bit versions of the Windows Installer files that are installed have the same version number.
The Windows Installer files for the 32-bit version of the server tools and for the 64-bit version of the server tools
Device Software Development Kit (SDK)
The global version of this cumulative update package has the file attributes (or later file attributes) 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 item in Control Panel.
Note The installation files for 32-bit and 64-bit versions of SQL Server Compact 3.5 SP2 are included in a single package.
For all supported 32-bit versions of SQL Server Compact 3.5 SP2