Microsoft SQL Server 2012 Service Pack 2 Express

Microsoft made available for download the SQL Server 2012 Service Pack 2 (SP2) Express. Microsoft SQL Server 2012 SP2 Express is a free, feature-rich editions of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.

Microsoft SQL Server 2012 SP2 Express release includes the full version of SQL Server 2012 Management Studio with SP2 instead of SQL Server 2012 Management Studio Express. For a complete list of supported features in SQL Server Management Studio, see Features in SQL Server Management Studio.

LocalDB (SqlLocalDB)
LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. It can be bundled with Application and Database Development tools like Visual Studio and or embedded with an application that needs local databases.

Express (SQLEXPR)
Express edition includes the SQL Server database engine only. Best suited to accept remote connections or administer remotely.

Express with Tools (SQLEXPRWT)
This package contains everything needed to install and configure SQL Server as a database server including the full version of SQL Server 2012 Management Studio with SP2. Choose either LocalDB or Express depending on your needs above.

SQL Server Management Studio Express (SQLManagementStudio)
This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, full version of SQL Server 2012 Management Studio with SP2, etc. Use this if you already have the database and only need the management tools.

Express with Advanced Services (SQLEXPRADV)
This package contains all the components of SQL Server Express including the full version of SQL Server 2012 Management Studio with SP2. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.

Download Microsoft SQL Server 2012 Service Pack 2 Express
For a full description of the system requirements, and the download links, see: Microsoft SQL Server 2012 Service Pack 2 Express. Download the files most appropriate for you.

Limitations:
Microsoft SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB storage.

Source:
SQL Server 2012 SP2 Release Notes

No comments: