Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Jul 2, 2002

SQL Server 2000 Service Pack 2 Released

By Forrest Stroud

SQL Server 2000 Service Pack 2 Now Available

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




MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date