[Last Call] Learn how to a build a cloud-first strategyRegister Now


Difference: SQL Server 2005 Express vs SQL Server 2008 Express

Posted on 2009-02-17
Medium Priority
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
  • 2
LVL 39

Accepted Solution

BrandonGalderisi earned 2000 total points
ID: 23664502
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

ID: 23670955
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

ID: 23671142
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.

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

830 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