Fixed memory size on MSDE

I would like to limit memory (RAM) usage for MSDE.
Since there is no Enterprise manager - is there another way how to do it?
(-> SQL command?!)
Thank You
PetrHi Petr
Please read about sp_configure in the Books Online.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Petr Stejskal" <petr.stejskal@.txn.cz> wrote in message
news:uoi1VuKnDHA.1884@.TK2MSFTNGP09.phx.gbl...
> I would like to limit memory (RAM) usage for MSDE.
> Since there is no Enterprise manager - is there another way how to do it?
> (-> SQL command?!)
> Thank You
> Petr
>

five connection limit

Hi!
Everybody know that MSDE (based on SQL Server 2000) has five-connection
limit after which its performance degrades. Do SQL server 2005 Express
edition also has five-connection limit? Or this limit was dropped?Hi
No connection limit in Express though a performance throttle, but it is
limited to use only 1 CPU, 1GB RAM and a database can have a maximum data
size of 4GB.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Igor Solodovnikov" <IgorSolodovnikov@.discussions.microsoft.com> wrote in
message news:op.s2ltu9n6n8ihmu@.iw2k.helpmicro.local...
> Hi!
> Everybody know that MSDE (based on SQL Server 2000) has five-connection
> limit after which its performance degrades. Do SQL server 2005 Express
> edition also has five-connection limit? Or this limit was dropped?|||The limit was removed in SQL 2005 Express. See
http://msdn2.microsoft.com/en-us/library/ms165672.aspx.
Happy Holidays
Dan Guzman
SQL Server MVP
"Igor Solodovnikov" <IgorSolodovnikov@.discussions.microsoft.com> wrote in
message news:op.s2ltu9n6n8ihmu@.iw2k.helpmicro.local...
> Hi!
> Everybody know that MSDE (based on SQL Server 2000) has five-connection
> limit after which its performance degrades. Do SQL server 2005 Express
> edition also has five-connection limit? Or this limit was dropped?