SQL Server CE 1.1 Service Pack 1 Update
April 11, 2002
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:
Additional information on SQL Server CE (and a trial download) can be found at: