A lot of questions had been asked in forums about the difference between SQL Server 2000 and 2005. Below is a table which shows the components of both versions:
| Component | SQL Server 2000 | SQL Server 2005 |
|---|---|---|
| Extract, transformation, and load | Data Transformation Services (DTS) | SQL Server 2005 Integration Services |
| Relational data warehouse | SQL Server 2000 relational database | SQL Server 2005 relational database |
| Multidimensional database | SQL Server 2000 Analysis Services | SQL Server 2005 Analysis Services |
| Data mining | SQL Server 2000 Analysis Services | SQL Server 2005 Analysis Services |
| Managed reporting | SQL Server 2000 Reporting Services | SQL Server 2005 Reporting Services |
| Ad hoc reporting | | SQL Server 2005 Reporting Services |
| Ad hoc query and analysis | Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal) | Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal) |
| Database development tools | SQL Server 2000 Enterprise Manager, Analysis Manager, Query Analyzer, various other | SQL Server 2005 Business Intelligence Development Studio |
| Database management tools | Enterprise Manager, Analysis Manager | SQL Server 2005 SQL Server Management Studio |