MSDE - Myths Dispelled
If you're an XP Embedded developer you're probably aware that we redistribute MSDE as your default DB engine to host the embedded dependency database used by Target Designer and Component Designer.
One question the Embedded team sees once in a while is regarding the benefits of MSDE vs. full SQL server especially wrt any connection limitations that may prevent MSDE from being usable in some dev environments.
Euan Garden is a Group Program Manager on the SQL team, he has a really good article on SQL Myth Busting wrt the connection limits for MSDE/SQL Express. Check it out.
- Andy