<div>
Here's the list of features between editions:<br />
<br />
<a href="http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx" rel="ugc">http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx</a><br />

</div>


Here's the list of features between editions:

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx [http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx]


<div>
Database wise you will be able to manage but you wont get any BI tools like SSIS, SSAS, SSRS.
</div>


Database wise you will be able to manage but you wont get any BI tools like SSIS, SSAS, SSRS.

<div>
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.
</div>


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.

<div>
rpkhare:<br />
Is there a limit to the number of Users that can be logged in at once? 
</div>


rpkhare:
Is there a limit to the number of Users that can be logged in at once?

<div>
<div class="content wysiwyg-content">
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.<br />
<br />

</div>
</div>


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.



SQL Express vs SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.