<Dd> The compact edition is an embedded database engine . Unlike the other editions of SQL Server, the SQL CE engine is based on SQL Mobile (initially designed for use with hand - held devices) and does not share the same binaries . Due to its small size (1 MB DLL footprint), it has a markedly reduced feature set compared to the other editions . For example, it supports a subset of the standard data types, does not support stored procedures or Views or multiple - statement batches (among other limitations). It is limited to 4 GB maximum database size and cannot be run as a Windows service, Compact Edition must be hosted by the application using it . The 3.5 version includes support for ADO.NET Synchronization Services . SQL CE does not support ODBC connectivity, unlike SQL Server proper . </Dd> <Dd> SQL Server Developer Edition includes the same features as SQL Server Enterprise Edition, but is limited by the license to be only used as a development and test system, and not as production server . Starting early 2016, Microsoft made this version free of charge to the public . </Dd> <Dt> Embedded (SSEE) </Dt> <Dd> SQL Server 2005 Embedded Edition is a specially configured named instance of the SQL Server Express database engine which can be accessed only by certain Windows Services . </Dd>

Who manufactures sql server and what is this dbms' current version number