Microsoft recently released Service Pack 1 (SP1) for the Windows CE Edition of Microsoft SQL Server 2000 (SQL Server CE) v1.1. The new Service Pack offers support for Windows CE .NET devices. Other additions include support for the new Pocket PC 2002 Software Development Kit (SDK) and the Handheld PC 2000 SDK, as well as integrated extensions of enterprise applications, which are now recognized as part of the SQL Server CE setup (so mobile application developers can build on these new Windows CE operating environments).
From Microsoft, “You can use SQL Server CE 1.1 with SP1 to take advantage of larger storage technologies for mobile devices. To minimize main RAM usage, SQL Server CE 1.1 with SP1 enables you to locate the temporary databases used to store data during processing, queries, replication, and so forth on alternative storage devices, such as removable storage (CompactFlash, Microdrive, and so on). This way your system won’t run out of memory when it creates temporary database files during complex processing. Main memory is now conserved for the main database file and application.
“A set of important software updates are included in this service pack. You should install SQL Server CE 1.1 SP1 to ensure that you have the latest set of program updates. SQL Server CE 1.1 SP1 provides operating environment updates and software fixes for the SQL Server CE Developer Tools and device software components only. This service pack does not include any updates to the server-side replication components that reside on the Internet Information Services (IIS).”
SQL Server CE 1.1 Service Pack 1 can be downloaded at:
http://www.microsoft.com/sql/downloads/CE/v11SP1.asp
Additional information on SQL Server CE (and a trial download) can be found at:
http://www.microsoft.com/sql/CE/default.asp
DatabaseJournal.com publishes relevant, up-to-date and pragmatic articles on the use of database hardware and management tools and serves as a forum for professional knowledge about proprietary, open source and cloud-based databases--foundational technology for all IT systems. We publish insightful articles about new products, best practices and trends; readers help each other out on various database questions and problems. Database management systems (DBMS) and database security processes are also key areas of focus at DatabaseJournal.com.
Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved
Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.
