Microsoft SQL Server 2012 Internals

SQL Server editions

Each version of SQL Server comes in various editions, which you can think of as a subset of the product features, with its own specific pricing and licensing requirements. Although this book doesn’t discuss pricing and licensing, some of the information about editions is important because of the features available with each edition. SQL Server Books Online describes in detail the editions available and the feature list that each supports, but this section lists the main editions. You can verify what edition you are running with the following query:

SELECT SERVERPROPERTY('Edition');

You can also inspect a server property known as EngineEdition:

SELECT SERVERPROPERTY('EngineEdition');

The EngineEdition property returns a value of ...