Microsoft Rolls Out SP3 for SQL Server
SQL Server 2000 Service Pack 3 includes serviceability and security fixes and enhancements.Microsoft Corp. Tuesday announced the availability of SQL Server 2000 Service Pack 3, which includes serviceability and security fixes and enhancements. SP3 includes all SQL Server fixes to date and is available by clicking here. It can be applied to an original installation or to one where SP1 or SP2 was applied previously. New features in SP3 include Analysis Services. Analysis Services include remote partitions and support for third-party data mining algorithm providers. SP3 also brings improvements in the manageability of SQL Server Agent logging. Also, replication enhancements are included to improve performance and reliability.
Microsoft promises updated serviceability via a new error-reporting setting that enables SQL Server to be configured to have critical errors automatically sent to Microsoft. Also included in SP3 is improved multi-server administration and a new monitoring API that allows database administrators or third-party tools to diagnose problem processes such as Precise/In-depth for SQL Server.