Description of SQL Server Compact 3.5 Service Pack 2


Introduction


This article describes Microsoft SQL Server Compact 3.5 Service Pack 2 (SP2). SQL Server Compact 3.5 SP2 updates the release version of SQL Server Compact 3.5. This article includes the following items:

More Information


Version history

The following list contains the different releases of Microsoft SQL Server Compact:
  • Version 3.5 SP2: Microsoft SQL Server Compact 3.5 Service Pack 2 (SP2). This service pack was released together with Visual Studio 2010 and on the web.
  • Version 3.5 SP1: Microsoft SQL Server Compact 3.5 Service Pack 1 (SP1). This service pack was released together with Microsoft Visual Studio 2008 Service Pack 1 (SP1) and with Microsoft SQL Server 2008.
  • Version 3.5: Microsoft SQL Server Compact 3.5. This version was released together with Microsoft Visual Studio 2008.
  • Version 3.1: Microsoft SQL Server 2005 Compact Edition. This version was released at the same time for integration with Microsoft Visual Studio 2005 Service Pack 1 (SP1) and with Microsoft SQL Server 2005 Service Pack 2 (SP2).
  • Version 3.0: Microsoft SQL Server 2005 Mobile Edition (SQL Server Mobile). This version was released together with Microsoft Visual Studio 2005 and with Microsoft SQL Server 2005.
  • Version 2.0: Microsoft SQL Server 2000 Windows CE Edition 2.0 (SQL Server CE 2.0). This version was released together with Microsoft Visual Studio 2003.

New features

SQL Server Compact 3.5 SP2 includes the following new features:
  • Supports working with a SQL Server Compact 3.5 database when you use the Transact-SQL Editor in Visual Studio 2010. The Transact-SQL Editor can be used to run free-text Transact-SQL queries against a SQL Server Compact 3.5 database. The Transact-SQL Editor also lets you view and save detailed estimated and actual query show-plans for SQL Server Compact 3.5 databases. Previously, the functionality that is provided by the Transact-SQL Editor was available only through SQL Server Management Studio.
  • New classes and members that are named SqlCeChangeTracking are added to the System.Data.SqlServerCe namespace to expose the internal change tracking feature that is used by Sync Framework to track changes in the database. The SQL Server Compact change tracking infrastructure maintains information about inserts, deletes, and updates that are performed on a table that is enabled for change tracking. This information is stored both in columns that are added to the tracked table and in system tables that are maintained by the tracking infrastructure. By using System.Data.SqlServerCe.SqlCeChangeTracking, you can configure, enable, and disable change tracking on a table. You can also access the tracking data that is maintained for a table. The API can be used to provide functionality in many scenarios. For example, the API can be used to provide custom implementations of client-to-server or client-to-client sync for occasionally connected systems (OCS) or to implement a custom listener application.
  • The managed assemblies of SQL Server Compact for use by the applications that privately deploy SQL Server Compact are installed in the following folder:
    %Program Files%\Microsoft SQL Server Compact Edition\v3.5\Private
    By using these assemblies, the application makes sure to use the privately deployed version of Compact even when an earlier version of SQL Server Compact 3.5 is installed in the GAC.
  • Visual Studio 2010 installs both the 32-bit and 64-bit versions of SQL Server Compact 3.5 SP2 on a 64-bit computer. If a SQL Server Compact application is deployed by using Click Once in Visual Studio 2010, both the 32-bit and the 64-bit version of SQL Server Compact are installed on a 64-bit computer.
  • SQL Server Compact 3.5 SP2 supports Windows 7 and Windows Server 2008 R2 and can sync data by using merge replication with SQL Server 2008 R2.

List of fixes that are included

In addition to new software updates, the hot fixes that were released for SQL Server 2005 Compact Edition and SQL Server Compact 3.5 SP1 are also included in the following list for SQL Server Compact 3.5 SP2:
  • 953259 Error message when you run an SQL statement that uses the Charindex function in a database that uses the Czech locale in SQL Server 2005 Compact Edition: "The function is not recognized by SQL Server Compact Edition"
  • 958478 Error message when you run a "LINQ to Entities" query that uses a string parameter or a binary parameter against a SQL Server Compact 3.5 database: "The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses"
  • 959697 Error message when you try to open a database file from a CD in SQL Server Compact 3.5 with Service Pack 1: "Internal Error using read only database file"
  • 960142 An error message is logged, and the synchronization may take a long time to finish when you use an application to synchronize a merge replication that contains a SQL Server 2005 Compact Edition subscriber
  • 963060 An error message is logged, and the synchronization may take a long time to finish when you synchronize a merge replication that contains a SQL Server Compact 3.5 subscriber: "UpdateStatistics Start app=<UserAppName>.exe"
  • 967963 Some rows are deleted when you repair a database by using the Repair method together with the RepairOption.RecoverCorruptedRows option in SQL Server 2005 Compact Edition and in SQL Server Compact 3.5
  • 968171 Error message when you try to create an encrypted database in SQL Server 2005 Compact Edition: "The operating system does not support encryption"
  • 968864 Error message when you run a query in SQL Server Compact 3.5: "The column name cannot be resolved to a table. Specify the table to which the column belongs"
  • 969858 Non-convergence occurs when you synchronize a SQL Server Compact 3.5 client database with the server by using Sync Services for ADO.NET in a Hub-And-Spoke configuration
  • 970269 Access violations occur when you run an application under heavy load conditions after you install the 64-bit version SQL Server Compact 3.5 Service Pack 1
  • 970414 Initial synchronization of a replication to SQL Server Compact 3.5 subscribers takes significant time to finish
  • 970915 Error message when you synchronize a merge replication with SQL Server 2005 Compact Edition subscribers: "A column ID occurred more than once in the specification. HRESULT 0x80040E3E (0)"
  • 971027 Error message when you upgrade a very large database to SQL Server Compact 3.5: "The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only"
  • 971273 You do not receive error messages when you run a query in a managed application that returns columns of invalid values in SQL Server Compact 3.5
  • 971970 You cannot insert rows or upload changes into the SQL Server 2005 Compact Edition subscriber tables after you run the "sp_changemergearticle" stored procedure or you add a new merge publication article when another article has an IDENTITY column
  • 972002 Error message when you try to create an encrypted database in SQL Server Compact 3.5: "The operating system does not support encryption"
  • 972390 The application enters into an infinite loop when you run an application that uses Microsoft Synchronization Services for ADO.NET to synchronize a SQL Server Compact 3.5 database
  • 972776 When the application calls the SqlCeConnection.Close method or the SqlCeConnection.Dispose method in SQL Server Compact 3.5, the application may stop responding at the method call
  • 974068 Error message when an application inserts a value into a foreign key column in SQL Server Compact 3.5: "No key matching the described characteristics could be found within the current range"