SQL Server management Studio is the primary tool that use against SQL Server.
It is not difficult to find the comparison between SQL Server Edition and the Free express version. However, it is not so much discussion for the management tools itself.
We know that the SSMS express version looks like a full version of the SSMS but in fact it actually not the full version and lack many functionality. In order to get the full version of the SSMS, we have to install it from the license media.
Good news is , it is no longer the case with SQL Server 2012 SP1.
With SQL Server 2012 SP1, the full feature of the SSMS is free to download. Here. The binary name is SQLManagementStudio_x64_ENU.exe. The Size is over 900MB which is significant large than the RTM version here ( 600 MB).
The SSMS Express now has the selection “Basic” and “Complete”, just like the licensed media.
There is no express word when we start the SSMS.
SSMS has full set of the SQL Profiler .