Database size limit

What is the differences between SQL server 2005 Express and SQl Server 2005?
What would be the database size limit of these 2?SQL Server 2005 Express has a limit of 4 GB for database size, while the
other editions do not have a limit. See the complete feature comparison
chart here:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||So the database engine of SQL Server 2005 Express and SQL server 2005 are
different?
"Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
news:ezOp1DmzHHA.4652@.TK2MSFTNGP05.phx.gbl...
> SQL Server 2005 Express has a limit of 4 GB for database size, while the
> other editions do not have a limit. See the complete feature comparison
> chart here:
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>|||Yes, Express has some artificial limits. If that weren't the case, then no-one would pay for the
product.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:OPRViiozHHA.4004@.TK2MSFTNGP05.phx.gbl...
> So the database engine of SQL Server 2005 Express and SQL server 2005 are
> different?
> "Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
> news:ezOp1DmzHHA.4652@.TK2MSFTNGP05.phx.gbl...
>> SQL Server 2005 Express has a limit of 4 GB for database size, while the
>> other editions do not have a limit. See the complete feature comparison
>> chart here:
>> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
>> HTH,
>> Plamen Ratchev
>> http://www.SQLStudio.com
>>
>|||I see.
MS pose that limit on express edition.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:B35D9F2D-7E3B-4868-A4E5-476FF3523CE2@.microsoft.com...
> Yes, Express has some artificial limits. If that weren't the case, then
no-one would pay for the
> product.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
> news:OPRViiozHHA.4004@.TK2MSFTNGP05.phx.gbl...
> > So the database engine of SQL Server 2005 Express and SQL server 2005
are
> > different?
> >
> > "Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
> > news:ezOp1DmzHHA.4652@.TK2MSFTNGP05.phx.gbl...
> >> SQL Server 2005 Express has a limit of 4 GB for database size, while
the
> >> other editions do not have a limit. See the complete feature comparison
> >> chart here:
> >> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> >>
> >> HTH,
> >>
> >> Plamen Ratchev
> >> http://www.SQLStudio.com
> >>
> >>
> >
> >
>sql