SQL Server CE 1.1 Service Pack 1

Important: Microsoft has updated Microsoft SQL Server 2000 Windows® CE Edition (SQL Server CE) version 1.1 Service Pack 1 (SP1) to include support for Windows CE .NET devices. SQL Server CE 1.0 users must upgrade to SQL Server CE 1.1 before applying this service pack. Read SQL Server CE 1.1 SP1 Readme.txt Addition on the PSS site for instructions on how to determine which version of SQL Server CE you have installed.
New in Service Pack 1

SQL Server CE 1.1 SP1 provides support for the new Pocket PC 2002 Software Development Kit (SDK), the Handheld PC 2000 SDK, and Windows CE .NET devices. Extensions of enterprise applications are now integrated and recognized as part of the SQL Server CE setup, so mobile application developers can build on these new Windows CE operating environments.

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.

Installing SQL Server CE

A SQL Server 2000 Windows® CE Edition (SQL Server CE) installation includes up to four systems: a system running SQL Server¹, a system running Microsoft Internet Information Services (IIS)², a development system³, and a Windows CE–based device4. You can use the same computer as the SQL Server system, the IIS system, and the development system.

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.

Hard Disk SQL Server CE on an IIS system
120 megabytes (MB) of available hard disk space.

SQL Server CE on a development system
30 MB of available hard disk space.

SQL Server CE on a Windows CE–based device
1–3 MB of available storage space, depending on processor type, operating system version, and components installed.
Operating system SQL Server CE on an IIS system
Microsoft Windows® NT® operating system version 4.0 with Service Pack 5 or later, or the Windows 2000 operating system.

SQL Server CE on a development system
Microsoft Windows 98, Windows Millennium Edition, Windows NT 4.0 with Service Pack 5 or later, Windows 2000, or Windows XP.

Note: Windows 98 does not support Windows CE desktop emulation.

SQL Server CE on a Windows CE–based device
Windows CE operating system version 2.11 or later for a Handheld PC Pro (H/PC Pro) or Palm-size PC (P/PC); Windows CE 3.0 or later for a Pocket PC 2002, Pocket PC and Handheld PC 2000.
Other Devices SQL Server CE on an IIS system
Microsoft Internet Explorer version 5.0 or later.

SQL Server CE on a development system
Internet Explorer 5.0 or later to access HTML Help.

You are not currently logged-in. To download you must be logged-in and be a subscriber or have met our community quality and reputation requirements as a free user - Find out more · Subscribe

Support the Site

Please help to pay for the download that you are getting from us today and help to support our desire to run the site without paid subscriptions or advertising by making a donation to the site. It doesn't matter how much or little you donate, but by donating you will help to ensure that we can continue to offer some of the Internet's most popular, rarest and unusual downloads for Windows CE devices for now and for the future.