I know all the SQL Server versions from 2005 to 2014 have an express edition. This question is specifically about SSMS. There was an SSMS Express 2005, 2008, and 2008 R2, but I haven't found any later version.
What versions of SSMS have an Express edition
ssms
Related Question
- SQL Server 2008 R2 Management Studio – Evaluation Period Expired Fix
- Sql-server – Does SSMS follow the same support lifecycle as SQL Server
- MSSQL – Export Wizard Unable to Save SSIS Package
- SSMS – How to Permanently Fix IntelliSense Poor Functioning
- SSMS Object Explorer Hangs When Expanding Databases List – Fix
- SSMS – How to Make a Query Fail for Higher Versions of SQL Server
Best Answer
The SSMSE was different in what it can manage as documented here.
Now you can use SSMS (SQL Server Management Studio) as a seperate download - SSMS or SQL server 2014 express - SSMSE that will manage all editions of sql server.
Aaron has a really good explanation here with screenshots :-)