There's some enterprise level functionality missing such as SIS (new DTS).
MSDE didn't limit number of users it was choked in terms of the number of concurrent batches.
You should also bear in mind SQL 2005 is significantly and in my opinion disasterously slower in terms of processing ad-hoc queries, prepared or not.
It's still faster than access though.
Keep Up with TechRepublic