-1

I try to understand the difference between SQL Server Management Studio and SQL Server Management Studio Express

criticalfix
  • 2,870
  • 1
  • 19
  • 32
Raza Muhammad Dahri
  • 41
  • 1
  • 1
  • 4
  • 1
    duplicate http://stackoverflow.com/questions/117347/whats-the-difference-between-sql-server-management-studio-and-the-express-editi – kenny Mar 29 '15 at 15:35
  • 3
    Management Studio is just a User Interface to work with SQL Server (With Any Version/License of SQL Server) , Express , Standard , Enterprise , Developers are different Licenses of SQL Server with different feature and Limitations. – M.Ali Mar 29 '15 at 15:36
  • **How to find SQL management studio after installing SQL server 2012 express edition** – Raza Muhammad Dahri Mar 29 '15 at 16:06
  • Rolled back to the last version edited by @marc_s because the question text had apparently been vandalized by OP. – criticalfix Sep 19 '18 at 17:10

2 Answers2

1

The "full" SQL Server Management Studio is the management GUI (graphical user interface) to work with a SQL Server database and is included in all the paid editions of SQL Server.

For the free SQL Server Express edition, SQL Server Management Studio Express can be downloaded for free from the Microsoft web site (or is include, as well, in the "Express with Tools" edition). As far as I know, as of SQL Server 2012, the two versions are essentially the same and don't have any differences in terms of features or capabilities they offer

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
  • **How to find SQL management studio after installing SQL server 2012 express edition** – Raza Muhammad Dahri Mar 29 '15 at 16:06
  • [This page here lists ***ALL*** the SQL Server **Express** related bits to download](http://www.microsoft.com/en-us/download/details.aspx?id=35579). You either need `SQLManagementStudio_x86_ENU.exe` (32-bit) or `SQLManagementStudio_x64_ENU.exe` (64-bit) depending on your installation of SQL Server **Express** .... – marc_s Mar 29 '15 at 16:08
0

Microsoft makes money from licensed SQL Server - it does not make money from Express. So everything about express is going to be crippled in some way.

SSME (SQL Server Management Express) does not have help and does not support any features SQL Server Express does not support - Reporting Services,SQL Server Agent, Analysis Services etc. If you, or your company, cannot afford a licensed version you are stuck with Express but don't expect a go cart to be as good as a car.

benjamin moskovits
  • 5,261
  • 1
  • 12
  • 22