Difference: SQL Server 2005 Express vs SQL Server 2008 Express

Posted on 2009-02-17
Last Modified: 2012-05-06
We have an app that we were planning on sending out with a copy of SQL Server 2005 Express.  However since the 2008 version is out I am just wondering if there is a reason to not use it.

One of my biggest concerns is what has changed in the 2008 version.  I can find an abundance of information on the 2005 Express restrictions and such but not finding a lot on the 2008 version.   Aside from basic OS and PC requirements.

So I guess Im looking for 3 things mainly:
1) Whats the difference between the 2005 and 2008 Express versions?
2) Which would be recommended to use?
3) I know 2005 version has no connection restrictions but I can't seem to find that info anywhere on the 2008 version.  What are its restrictions?  Our app needs no connection restrictions since multiple connections will be required.

I'm no SQL expert by any means so assume I need the extra details in any explanation.
Question by:CI3
    LVL 39

    Accepted Solution

    2008 has introduced new features including the more granular datetime2 data type as well as date and time data types.  The ability to pass table variables as parameters into stored procedures was also introduced in 2008.  

    Beyond that, the major changes are improvements to the DB engine.

    2008/2005 have very similar, if not identical, restrictions on connections and db sizes.

    Author Comment

    Thanks, any links you can give that show - 2008 allows unlimited connections?  I can't seem to find any info on that.
    LVL 39

    Expert Comment

    This page compares the editions.

    There is no mention about unlimited connections.  And it's not UNLIMITED.  It's limited by system resources on the host.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how the fundamental information of how to create a table.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now