Description of the various build versions of SQL Server Compact Edition

INTRODUCTION

This article describes the build versions of Microsoft SQL Server Compact Edition.

More Information

Build versions of SQL Server Compact Edition

Product name	Release channel	Build version	Public product version
SQL Server 2005 Mobile Edition	The release version of Microsoft Visual Studio 2005	3.0.5206	3.0
SQL Server 2005 Mobile Edition	The release version of SQL Server 2005	3.0.5207	3.0
SQL Server 2005 Mobile Edition	Microsoft Download Center	3.0.5214	3.0
SQL Server 2005 Compact Edition	Windows Mobile 6.0	3.0.5289	3.1
SQL Server 2005 Compact Edition	Visual Studio 2005 Service Pack 1 (SP1)	3.0.5300	3.1
SQL Server 2005 Compact Edition	SQL Server 2005 SP2	3.0.5300	3.1
SQL Server 2005 Compact Edition	Microsoft Download Center	3.0.5300	3.1
SQL Server 2005 Compact Edition	Windows Mobile 6.5	3.0.5300.8	3.1
SQL Server Compact 3.5	The release version of Visual Studio 2008	3.5.5386	3.5
SQL Server Compact 3.5	Microsoft Download Center	3.5.5386	3.5
SQL Server Compact 3.5 SP1	Visual Studio 2008 Service Pack 1 (SP1)	3.5.5692	3.5
SQL Server Compact 3.5 SP1	The release version of SQL Server 2008	3.5.5692	3.5
SQL Server Compact 3.5 SP1	Microsoft Download Center	3.5.5692	3.5
SQL Server Compact 3.5 SP2	Visual Studio 2010	3.5.8080	3.5
SQL Server Compact 3.5 SP2	SQL Server 2008 R2	3.5.8080	3.5
SQL Server Compact 3.5 SP2	Microsoft Download Center	3.5.8080	3.5

Note The Release channel column refers to the product or the Web site that provides the specific build version of SQL Server Compact Edition.

How to obtain the build version of SQL Server Compact

To obtain the build version of SQL Server Compact that is running on the computer, check the version of the SQL Server Compact DLLs. To obtain the build version of the DLLs, follow these steps:

Locate a SQL Server Compact Edition DLL in the following folder:
%ProgramFiles%\Microsoft SQL Server Compact Edition
For example, the Sqlceca35.dll file is one of the DLLs for SQL Server Compact 3.5.
Right-click a SQL Server Compact Edition DLL, and then click Properties.
In the Properties dialog box, click the
Version tab.
On the Version tab, notice the number after File version.

If you installed SQL Server Compact 3.5 or a later version, you can also follow these steps to obtain the build version:

Click Start, click Run, type regedit, and then click
OK.
Locate the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ Microsoft SQL Server Compact Edition\<ProductVersion>
Note ProductVersion is a placeholder for the product version of SQL Server Compact that is running on the computer. For example, if SQL Server Compact 3.5 is running on the computer, the value of
ProductVersion is v3.5.
Notice the value of the DesktopRuntimeVersion registry entry.

↑ Back to the top

Keywords: kb, kbinfo, kbhowto, kbexpertiseadvanced