Discussion on:

Message 26 of 32
0 Votes
+ -
There's no choke in SQL Express
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.
Posted by Tony Hopkinson
8th Dec 2006