MS is lowering the price on this version to $49. I'm assuming that it should have EM included but can't tell for sure. Anyone know what exactly this version is and what is included? If EM is included, it would be well worth the price...
received a reply on the MS newsgroups. here is what he said, "The USD $49 figure is correct. The Developer Edition has all of the features of the full-blown Enterprise Edition. The difference is in licensing."
$49 seems quite reasonable, and is the "official" way to learn and develop on MSSQL. If it comes with supporting CDROMs and manuals, you should probably go for the deal.
However, if it's just a CDROM and a license, then you're much better off installing MSDE 2000 (obtained from an Office XP CD, but also from a few other MS and / or 3rd party application CDs), then downloading the SQL Server 2000 trial and installing the Enterprise tools only - that'll give you a virtually identical setup (to the "Developer Edition") for free!! Same tools, same engine, same help files, same everything.
That's what I and countless others use for local development, and it's as good as the real thing, *apart* from having a restricted number of concurrent users (which is fine for development).
MSDE doesn't do Indexed views, I recall. Also, maximum DB size of 2 GB and it throttles the number of threads used. Also, no chance of using fibers or paralell query execution. Also cant act as a transactional replication publisher, just a subscriber (bbut it can publish snapshot & megre replicas).
But apart from that, MSDE is by far the best desktop redistributable DB I have ever seen. It has an unbeaten value for money ration, in my opinion!