SQL Server 2005 Express Edition is based on the technology used for the line of products of SQL Servers 2005. It is a database manager of easy to use and represents the free version of this line of software. It has a robust graphical user interface that easily guides the users during its installation. It also includes (1) SQL Server Management Studio Express Edition that helps users to manage the databases and all the objects on the server and (2) SQL Server configuration Manager to help users to configure the communication ports and the IP addresses.
SQL Server 2005 Express Edition uses the same database engine as SQL Server 2005 professional edition. It also uses the same API for Data Access, the same Client and the same Control of Transaction for SQL Process. The differences among the Express version and the Professional version are: Express Version receives no support from Microsoft team, it is limited to one CPU, it is limited to 1 GB for the buffer pool, and the Database can just grow up to 4 GB (this applies to data files, not to log files). On the other hand the professional version has support from Microsoft team, it has no limit to one CPU and the limits on buffer pool and databases give a very big job space.
SQL Server 2005 Express Edition does not contain business intelligence features, and it has no limit for connected users. However, the limitation is created while the quantity of users is growing up and makes the response of the CPU slower. Each instance of SQL Server 2005 Express Edition allows to a non-administrator user to manage his own privileges on the SQL Server database.
SQL Server 2005 Express edition is a simplified version of the SQL Server 2005, but with the same technology .