Posted by Greg D. Moore \(Strider\) on 10/23/07 11:36

"Neil" <nospam@nospam.net> wrote in message
news:G0hTi.54$nN3.12@newssvr17.news.prodigy.net...
>>>> (BTW, you may want to look into upgrading the DB to use something like
>>>> SQL Express edition. More modern, better supported and may be a bit
>>>> faster, especially on a Windows 2003 box.)
>>>
>>> SQL Express? I thought SQL Express was the new version of SQL
>>> Desktop/MSDE. Maybe I'm wrong.
>>
>> It is. For many smaller applications, it's a great choice. For a 1 gig
>> database, I'd certainly consider it.
>>
>
> Isn't there a limitation on the number of users that can access the
> database? I thought that it was something like 10 users or something.
>

No, and there never has been. That's a misunderstanding of the old query
governer built into MSDE (whcih permitted only 5 or 6 (I've seen both
numbers)) of queries to run at the same time before things were slowed down
on purpose).

SQL Server Express 2005 does not have that limit. Rather it is limited in
DB size (2GB), CPU (1) and memory (I believe 1GB). But within those
parameters it operates at full-speed and works very well.


>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]