Monday, March 12, 2012

MSDE limitations lifted in Express?

8 connection limit, 2GB file size limit in MSDE? What are the limits in the
capabilities of SQL Express?
-billb
billb -
http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx
No 8 connection limit, 4GB database size, and some other things are
different.
RLF
"William Bernat" <Wil86ianospammb86ernat@.cap86tanospamaris.com> wrote in
message news:urA1lqAaHHA.3268@.TK2MSFTNGP04.phx.gbl...
>8 connection limit, 2GB file size limit in MSDE? What are the limits in the
>capabilities of SQL Express?
> -billb
>
|||Although it was not really an '8 connection' limit. See Euan Garden's
Mythbuster BLOG. http://blogs.msdn.com/euanga/archive/2006/03/09/545576.aspx
RLF
|||Thanks Russell!!!
-billb
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:ekDT08AaHHA.5056@.TK2MSFTNGP03.phx.gbl...
> Although it was not really an '8 connection' limit. See Euan Garden's
> Mythbuster BLOG.
> http://blogs.msdn.com/euanga/archive/2006/03/09/545576.aspx
>
> RLF
>
|||Indeed, there is not 8 concurrent queries limit, the 2GB database size
limit has been raised to 4GB, but the maximum RAM limit of 2GB has
been lowered to 1GB and SQL Server Agent is no longer included.
Razvan

No comments:

Post a Comment