>>4) MSDE is best under 5 users, 8 users? - M$ literature says 5 or fewer users, but a thread post said 8 or fewer. It wouldn't surprise me if it handled 10 fine, and M$ is keeping it secret. Anyone holding the truth captive?
>
>MSDE is optimized for up to 5 concurrent users.
>
Five cuncurrent BATCHES is a better way to put it. You can have multiple connections but MSDE will process no more than five concurrently.
-Mike