SQL Server 2000 Service Pack 2 (SP2) is divided into three parts to reduce the size of downloads: database components, Analysis Services components, and SQL Server 2000 Desktop Engine (MSDE).
Database Components
SP2 updates for the database components of SQL Server 2000 include:
- Data engine.
- Database client utilities, such as SQL Server Enterprise Manager and osql for SQL Server 2000.
- Database client connectivity components, such as the OLE DB Provider for SQL Server, the SQL Server Open Database Connectivity (ODBC) driver, and the client Net-Libraries.
Analysis Services Components
SP2 updates for the Analysis Services components of SQL Server 2000 include:
- Analysis Services engine.
- Analysis Services client components, such as Analysis Manager and the OLE DB Provider for Analysis Services.
- Database client connectivity components, such as the OLE DB Provider for SQL Server, the SQL Server ODBC driver, and the client Net-Libraries.
SQL Server 2000 Desktop Engine (MSDE)
SP2 updates for MSDE include:
- Data engine.
- Database client connectivity components, such as the OLE DB Provider for SQL Server, the SQL Server ODBC driver, and the client Net-Libraries.