News

SP3 Posted for SQL Server 2000

Microsoft updated its enterprise database, SQL Server 2000, this week with a service pack that includes bug fixes and some new and enhanced functionality.

Service Pack 3 for SQL Server 2000 is available at www.microsoft.com/sql/downloads/2000/sp3.asp.

Recently, Microsoft has been less strict than it was in the past about introducing new functionality in service packs for server software.

SQL Server 2000, meanwhile, is at something of an odd stage. SQL Server 2000 has already been on the market longer than SQL Server 7.0 was before it was replaced. With the next version of SQL Server, code-named "Yukon," being a major release, Microsoft has indicated it could be 2004 before there is a replacement for SQL Server 2000 on the market.

Microsoft groups the new functionality in SP3 in three areas: serviceability, performance and security. Serviceability enhancements include making SQL Server one of the products that can be configured to have critical errors automatically sent to Microsoft. Microsoft has also improved multi-server administration and added a new monitoring API to allow DBAs or third-party tools to diagnose problems.

In the performance area, Microsoft has added support for QLogic's Virtual Interface (VI)-enabled SANblade QLA2350 Fiber Channel controller. VI technology reduces CPU consumption per message on the server and on clients, improving performance.

For security, Microsoft has added the ability to run SQL Server Agent as a non-administrator and updated online documentation with more guidance for securing SQL Server.

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.

Featured

  • Microsoft Appoints Althoff as New CEO for Commercial Business

    Microsoft CEO and chairman Satya Nadella on Wednesday announced the promotion of Judson Althoff to CEO of the company's commercial business, presenting the move as a response to the dramatic industrywide shifts caused by AI.

  • Broadcom Revamps VMware Partner Program Again

    Broadcom recently announced a significant update regarding its VMware Cloud Service Provider (VCSP) program, coinciding with the release of VMware Cloud Foundation (VCF) 9.0, a key component in Broadcom’s private cloud strategy.

  • Closeup of the new Copilot keyboard key

    Microsoft Updates Copilot To Add Context-Sensitive Agents to Teams, SharePoint

    Microsoft has rolled out a new public preview for collaborative "always on" agents in Microsoft 365 Copilot, bringing enhanced, context-aware tools into Teams channels, meetings, SharePoint sites, Planner workstreams and Viva Engage communities.

  • Windows 365 Cloud Apps Now Available for Public Preview

    Microsoft announced this week that Windows 365 Cloud Apps are now available for public preview. This aims to allow IT administrators to stream individual Windows applications from the cloud, removing the need to assign Cloud PCs to every user.