Limitations in SQL Server 2005 Express

Is there any information on any limits in the facilities available in SQL
Server 2005 Express (compared with Standard edition)?
For example: database size, maximum number of users etc.
What features are not available in the Express edition?
Thanks,
Steve.There is a 4GB limit for database size in SQL Server Express. As far as
number of users I do not think there is any limitation. Here is the complete
feature comparison chart for the different editions:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||Hello,
Only advantage in SQL Express over SQL 2005 Standard edition is it is FREE
OF COST. SQL Express have below limitations:-
1. Maximum 4 GB database size
2. Allow only 1 GB RAM
3.Allow only 1 CPU
4. No Profiler
5. No SQL Agent to schedule jobs
The list goes on and on...
Thanks
Hari
"Sawlmgsj" <Sawlmgsj@.discussions.microsoft.com> wrote in message
news:948DDF45-3E76-4146-8610-3471873770C1@.microsoft.com...
> Is there any information on any limits in the facilities available in SQL
> Server 2005 Express (compared with Standard edition)?
> For example: database size, maximum number of users etc.
> What features are not available in the Express edition?
> Thanks,
> Steve.
>|||Many thanks for your comments and the link to Ms.
Steve.
--
"Hari Prasad" wrote:
> Hello,
> Only advantage in SQL Express over SQL 2005 Standard edition is it is FREE
> OF COST. SQL Express have below limitations:-
> 1. Maximum 4 GB database size
> 2. Allow only 1 GB RAM
> 3.Allow only 1 CPU
> 4. No Profiler
> 5. No SQL Agent to schedule jobs
> The list goes on and on...
> Thanks
> Hari
>
>
> "Sawlmgsj" <Sawlmgsj@.discussions.microsoft.com> wrote in message
> news:948DDF45-3E76-4146-8610-3471873770C1@.microsoft.com...
> > Is there any information on any limits in the facilities available in SQL
> > Server 2005 Express (compared with Standard edition)?
> >
> > For example: database size, maximum number of users etc.
> > What features are not available in the Express edition?
> >
> > Thanks,
> > Steve.
> >
>
>