There are certain functions it's blocked from performimg. Looking at it soon as a replacement for MSDE.
For the apps you'd use sqlexpress for MySQL would be better or PostGre. It's only real advantage is you can easily scale up to the full product when required.