SQL Server latest patches and tools-required for Database Administrators

I. Latest patch for SQL Server:
(1) SQL Server 2000 Service Pack 3A
Download SQL Server 2000 Service Pack 3A (sp3a)-latest and most complete SQL Server 2000 update Program It fixes some security vulnerabilities, including w32.slammer. : Http://www.microsoft.com/china/ SQL /downloads/sp3.asp
(2) Microsoft SQL Server 2000 Service Pack 4
Currently, SQL Server2000 SP4 has been released and is suitable for the latest and most complete update programs of SQL Server 2000.
However, note that the final version of SP4 has problems and may affect the customers who run SQL Server with awe enabled. This issue only affects computers with more than 2 GB of memory and awe enabled. SP4 should not be installed for customers who use this configuration.
: Http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = 8e2dfc8d-c20e-4446-99a9-b7f0109f8bc5
(3) SQL Server 7.0 Service Pack 4
SQL Server 7.0 Service Pack 4 (SP4) corrected the problems found in SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0.
: Http://www.microsoft.com/china/ SQL /downloads/sp4.asp
(4) SQL server6.5 Service Pack 5A
If you are still using SQL Server 6.5, install this software service package. Although not necessary, we recommend that you upgrade to SQL Server 7.0 during installation. To obtain the complete program error list corrected by the Upgrade Program, view the fixlist. asp file provided along with the software service package.
: Http://support.microsoft.com/kb/q197177/
(5) SQL Server 2000 Reporting Services Service Pack 1
Service Pack 1 (SP1) for Microsoft SQL Server 2000 reporting services includes bug fixes, performance improvements, and functional improvements. For example, you can view the data in Excel 97 and 2000. pdf rendering is more reliable and has better performance. Currently, You can reference external URLs (images and resources) in the report to preview cached data in the report; the new URL parameters provide more options to customize the display of runtime reports. Currently, hidden parameters and other enhancements are supported.
: Http://www.microsoft.com/downloads/details.aspx? Familyid = 580febf7-2972-40e7-bccf-6cd90ac2f464 & displaylang = ZH-CN
(6) SQL Server 2000 Reporting Services Service Pack 2
Service Pack 2 (SP2) of Microsoft SQL Server 2000 reporting services includes patches and some feature enhancements. For example, Sharepoint Web components allow you to use Microsoft Windows SharePoint Services or SharePoint Portal Server to view reports on the Report Server. Now you can print reports directly from Internet Explorer. Microsoft ActiveX control is provided to support a wide range of Client Print experiences, including full page preview.
: Http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = 502c0d89-1308-4662-8f58-cec55ef1235b
(7) Microsoft SQL Server 2000 driver for JDBC -- Service Pack 1
Microsoft SQL Server 2000 driver for JDBC is a type 4 JDBC driver that provides highly scalable and reliable connectivity for enterprise-level Java environments. This type of Driver provides JDBC with the ability to access SQL Server 2000 through Java-supported applets, applications, or application servers.
Http://www.microsoft.com/china/ SQL /downloads/jdbc_sp1.asp

Ii. SQL Server software tools:
(1) SQL Server Web Data Manager
You can easily manage your SQL Server and MSDE data wherever you are. Use this tool to create and edit databases, manage users and roles, Import and Export Database architectures and data, and so on-all of this is done in your favorite Web browser.
: Http://www.microsoft.com/downloads/details.aspx? Familyid = C039A798-C57A-419E-ACBC-2A332CB7F959 & displaylang = en
(2) SQLXML 3.0
SQLXML 3.0 introduces Web Services for SQL Server 2000 ). With SQLXML 3.0, stored procedures and (stored procedures) and XML templates can be exposed as a Web service through soap. SQLXML 3.0 also upgraded the support for diffgrams in SQLXML 2.0 and understood the new features added since Microsoft Visual Studio. NET beta 2 was released. In addition, it provides support for the released versions of. NET Framework and soap toolkit.
(3) The server guard against the latest Slammer Worm tools and programs.
: Http://www.microsoft.com/china/ SQL /downloads/securitytools.asp
(4) Best practices analyzer tool for Microsoft SQL Server 2000 1.0
Microsoft SQL Server best practices analyzer is a database management tool that lets you verify the implementation of common best practices on your servers.
Http://www.microsoft.com/downloads/details.aspx? Familyid = B414B00F-E2CC-4CAB-A147-EACA26740F19 & displaylang = en
(5) SQL Server health and history tool (sqlh2)
The Microsoft SQL Server health and history tool (sqlh2) allows you to collect information from instances of SQL Server, store this information, and run reports against the data in order to determine how SQL Server is being used.
: Http://www.microsoft.com/downloads/details.aspx? Familyid = eedd10d6-75f7-4763-86de-d2347b8b5f89 & displaylang = en
(6) Microsoft SQL Server 2005-Community Technology preview June 2005
Developer Edition, download the Community Technology Preview (CTP) of Microsoft SQL Server 2005.
Http://www.microsoft.com/downloads/details.aspx? Familyid = B414B00F-E2CC-4CAB-A147-EACA26740F19 & displaylang = en
(7) SQL Server 2000 reporting services evaluation Edition
Reporting Services is a server-based, comprehensive solution that can be used to create, manage, and provide paper-based reports as well as web-based interactive reports, http://www.microsoft.com/downloads/details.aspx? Familyid = BA517C01-2E2F-4BC7-84AF-149B7637F807 & displaylang = ZH-CN

3. Currently, only the msdn subscriber can download Visual Studio 2005 beta 2 and SQL Server 2005 beta 2.
If you first install Microsoft Visual Studio 2005 bata1, and then Install SQL Server 2005 bata2. during installation, you will be prompted to delete the original SQL server component. (even if you have never installed SQL Server, you will be prompted ). the reason is that the CLR version of Visual Studio 2005 bata1 is 2.0.40607.16, And the CLR version of SQL Server 2005 bata2 is 2.0.40607.42. solution: First Delete the framework of Visual Studio 2005 bata1 and run dotnetfx.exe on the Visual Studio 2005 bata1installation disk to delete it. then Install SQL server2005 bata2