Posted by Neil on 10/25/07 04:45

Thanks for the info. That's good to know.

"Greg D. Moore (Strider)" <mooregr_deleteth1s@greenms.com> wrote in message
news:13hrn2sbia0lt74@corp.supernews.com...
> "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]