Service Pack 2 (SP2) for SQL Server 2000 is now available from the Microsoft Web site. The latest service pack addresses specific issues that were discovered in SQL Server 2000 since the initial service pack was released. Because SQL Server Service Packs are cumulative, SP2 includes all fixes from the previously released Service Pack 1 (SP1), and can be applied to an original installation or to one where Service Pack 1 (SP1) was previously applied.
The SQL Server 2000 SP2 download is provided in three parts for the Database, Analysis Services, and Desktop Engine (MSDE) server components.
SP2 also contains an additional fix to English Query that needs to be downloaded and applied separately (for more information, see the “FIX: Potential English Query Security Issue” page). The three parts and the additional fix can all be downloaded at: http://www.microsoft.com/sql/downloads/2000/sp2.asp.
According to Microsoft, the following areas are updated with SP2:
Database Components
- 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
- 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
Desktop Engine (MSDE)
- 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
