To obtain rights to redistribute SQL Server 2005 Express Edition, you must register with Microsoft. To register, visit the Register for SQL Server 2005 Express Edition Redistribution Rights page.

SQL Server 2005 Express Edition with Advanced Services is a download that includes the SQL Server 2005 database engine, SQL Server 2005 Reporting Services, SQL Server 2005 Management Studio Express and Full-Text Search. SQL Server 2005 Management Studio Express will also be available separately as a download.

SQL Server Compact Edition is a lightweight , easy to deploy database system that is ideal for Windows database development. A 2MB footprint that requires no administration makes it an ideal solution for creating most data storage needs. Some of the limitations of SQL Server Compact Edition: Does not support stored procedures SQL Server Express is designed to be feature-rich and powerful database system. It is an ideal solution for creating client-server Windows applications and Web development.

SQL Server 2005 Express is an easy-to-use and free version of SQL Server 2005 that is designed for building simple, data-driven applications.

SQL Server 2005 Workgroup Edition has many of the key new features of SQL Server 2005, including programmability improvements such as CLR integration and SQL Service Broker support, Reporting Services, including the new end-user reporting tool, Report Builder, and SQL Server Management Studio, a new management tool for SQL Server 2005. These are all new features that come with SQL Server 2005 and are not available in SQL Server 2000 Standard Edition.

SQL Server Express is designed to meet the needs of simple applications. It is limited to using 1 CPU and up to 1GB RAM, with a 4GB maximum database size. SQL Server Express does not include any of the advanced components of SQL Server including Analysis Services, Reporting Services, Data Transformation Services, and Notification Services.

SQL Server 2005 Express Edition is available for download. Visit the How to Obtain SQL Server 2005 Express Edition page for details.

If you need to process a large number of bookings or support more than 10 concurrent users you should licence another edition of SQL Server. If you already use SQL Server in your organisation then you should approach your IT Department and see if they would prefer you to use SQL Server. If neither of the above apply, then the Express edition will be an ideal starting point and you can always upgrade to SQL Server at a later stage.

No. Personal Edition has been replaced by Express Edition and through Workgroup and Standard's ability to run on Windows XP.

SQL Server 2005 Developer Edition is licensed per developer and must be used for designing, developing, and testing purposes only.

In order for AppMetrics to function correctly with SQL Server 2005 Express, the Microsoft SQL Server 2005 Backward Compatibility Components package needs to be installed prior to the installation of AppMetrics. Note: Please ensure that TCP/IP is enabled on the SQL instance you will be using for AppMetrics, as TCP/IP is disabled by default and needs to be enabled in order for AppMetrics to connect.) Also, AppMetrics runs with both a named and default instance.

Live Communications Server Standard Edition uses Microsoft Desktop Engine (MSDE) as its presence registrar database, a core component of its presence and IM architecture. The Microsoft Desktop Engine does not require a separate licence and is shipped via the Live Communications Server CD. If you choose to use the optional Live Communications Server Archiving Services, then a separate physical SQL Server and licence will be required.

Live Communications Server 2005 Enterprise Edition uses a separate physical SQL 2000 server as its presence registrar, a core component of its presence and IM architecture. A separate physical SQL 2000 Server and license is required before attempting to install Live Communications Server 2005 Enterprise Edition. See the Live Communications Server planning and quick start guides on the Live Communications Server Deployment Center for more information.

The MSDN 2005 Express Edition Library is available as an optional component in the Visual Studio Express installers. If you choose to install the MSDN Express Library at a later time, you will need to rerun the Express installers to add the MSDN Express Library. There is no separate download available for the MSDN Express Library.

The MSDN Express Library contains additional product documentation and code samples for all Visual Studio Express Editions.

the Microsoft Full-Text Engine for SQL Server (MSFTESQL) service running a query to retrieve data from an indexed view, or The causes listed above are only a sampling of the issue slow response time issues encountered with SQL Server 2005. This slow response time can be rectified according to Microsoft by upgrading to the latest service pack for SQL Server 2005, Service Pack 2.