SQL Express vs SQL Server

What are the practical differences between SQL Express and SQL Server. What is the limit of concurrent users in Express? And is there anything that would run in Server that won't run in Express. I'm not referring to size of db or ram but feature wise.

curious77Asked:
Who is Participating?
 
rpkhareConnect With a Mentor Commented:
I don't think there is any limit to the number of users. However, go through these articles:

http://www.vsj.co.uk/articles/display.asp?id=442
http://www.sqlmag.com/Article/ArticleID/47721/sql_server_47721.html

I would recommend to go for SQL Server 2008 Express Edition with Advanced Services. You will get some more features.
0
 
BrandonGalderisiCommented:
Here's the list of features between editions:

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx
0
 
k_rasuriCommented:
Database wise you will be able to manage but you wont get any BI tools like SSIS, SSAS, SSRS.
0
 
rpkhareCommented:
SQL Express Edition is FREE fully-functional edition. It has a 4GB data limit and supports 1 server. You may not find enterprise features of SQL Server in it like Failover, clustering etc, but it is more than sufficient for small to mid-sized applications.
0
 
curious77Author Commented:
rpkhare:
Is there a limit to the number of Users that can be logged in at once?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.