Microsoft Rolls Out SP3 for SQL Server

By Lisa Vaas  |  Posted 2003-01-21 Print this article Print

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.
SP3 includes support for Qlogics VI-enabled SANblade QLA2350 Fibre Channel controller. The use of VI technology in the SQL Server networking layer reduces CPU consumption per message on server and client systems, according to Microsoft. Finally, security updates include a new version of Books Online, providing customers with more guidance on how to make environments secure. In addition, SP3 includes patches for known vulnerabilities reported by users or discovered through testing, as well as the ability to run SQL Server Agent as a non-administrator.
Lisa Vaas is News Editor/Operations for and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel