Is there any technical difference between these 2 editions or is it just how they are licenced?

link|improve this question

feedback

2 Answers

up vote 8 down vote accepted

They're close, but not quite the same. The primary difference is the licensing (as you mention). The other differences are around mirroring (web can only serve as a witness), pulishing (web can only subscribe), and perf (web does not come with SQL Profiler).

There are more differences when you get out of the SQL Engine and into SSIS, SSAS, and SSRS.

Full comparison of all editions here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

link|improve this answer
feedback

Since newer version(s) of SQL Server have been released, the feature comparison is tucked away in MSDN:

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.