Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

SQL Server Compact 3.5 SP2 Downloadable Update List

DZone's Guide to

SQL Server Compact 3.5 SP2 Downloadable Update List

Free Resource

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

The updates for SQL Server Compact 3.5 SP2 are now referred to a CU (Cumulative Update), which is what the hotfixes also were previously. The difference now is that the CU installation overwrites the existing installation, and a remove of the RTM bits is no longer required before installing the CU.

The table below gives an overview of the current CUs. All CUs apply to SQL Compact 3.5 SP2, version 3.5.8080.0.

Build KB Title Platforms
8081 982565 FIX: "An SqlCeParameter with ParameterName '<Parameter Name>' is not contained by this SqlCeParameterCollection" error message when you use the .NET Compact Framework Data Provider for SQL Server Compact to access SQL Server Compact 3.5 x86, x64
8082 983516

FIX: A Deadlock occurs when two transactions try to perform a DML operation on a table that contains a TABLOCK locking hint or an XLOCK locking hint

x86, x64
8082 2300599 FIX: Heap corruption occurs when you use SQL Server Compact 3.5 Service Pack 2 x86, x64
8083 2361070

FIX: Some "Image" column content does not open in SQL Server Compact 3.5 SP2 after the "SqlCeEngine.Compact" or "SqlCeEngine.Repair" method is called

x86, x64
8084 2479589

FIX:"A call to SQL Server Reconciler failed" error message occurs when you try to add or reinitialize a subscriber of SQL Server Compact 3.5 for a merge publication

Server Tools only,
x86, x64
8085 2494715

FIX: Incorrect result when you run a query that contains a conjunction and a disjunction in SQL Server Compact 3.5

x86, x64
8087 2585082 FIX: "A specified value violated the integrity constraints for a column or table" error if the merge publication contains many articles and constraints in SQL Server Compact 3.5 x86, x64
8088 2527494 A hotfix is available for SQL Server Compact 3.5 SP2 that adds support for replication with SQL Server "Denali" x86, x64, Server Tools, WinCE 5,6,7 (?)
8089 2665342 Incorrect sort order for a subscriber in SQL Server Compact 3.5 SP2 which synchronizes with a publisher in SQL Server Server Tools only,
x86, x64

Please let me know if there are errors or omissions.

It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate

Topics:

Published at DZone with permission of Erik Ejlskov Jensen, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}