在網路上找了一下, 看來在SQL Server 2008 或更早的版本裡, SSMS Express 跟 Enterprise/Standand 版本是不一樣的.
我覺得要看你的程式設計師需要什麼的功能, 如果只是基本的讀資料, Expres 版本應該就夠了
如果他需要用工具來Debug (像是 deadlock 問題), 或是 performance tuning, 或是管理Enterprise SQL server 的 Analysis/Integration/Reporting Services, 那需要看SSMSE 的版本.
以下是Reference:
1) 像是在2005/2008 版本裡, Express 沒有 Profiler - 可以讓工程師作觀察SQL server 的運作
Microsoft 的解釋:
-------------------------
For SQL Server 2008 R2:
http://msdn.microsoft.com/en-us/library/ms365247(v=sql.105).aspx
- SSMSE cannot manage Analysis Services, Integration Services, or Reporting Services.
- You cannot update the full-text catalog by using SSMSE. You can use sqlcmd utility or Windows Scheduler to update the full-text catalog.
- SSMSE does not support scheduling administrative tasks by using SQL Server Agent.
- .. etc
討論區 Reference
-------------
What's the difference between SQL Server Management Studio and the Express edition?
http://stackoverflow.com/questions/...e-express-editi
Is SQL Server 2008 Management Studio Express the same as Standard?
http://stackoverflow.com/questions/...ame-as-standard
2) 以下是關於在2012 的版本
討論區 Reference
---------------------------
Is SQL Server 2012 Management Studio “Express” any different?
http://dba.stackexchange.com/questi...s-any-different
Microsoft 的解釋:
------------------------
http://msdn.microsoft.com/en-us/evalcenter/hh230763
- Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)