Sunday, March 25, 2012

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/prodin...e-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/prodin...e-features.mspx
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>|||Yes, Express has some artificial limits. If that weren't the case, then no-o
ne 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...
>|||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...
are[vbcol=seagreen]
the[vbcol=seagreen]
>

No comments:

Post a Comment