News

SQL 2K SP1 Hits Web

Microsoft Corp. will publicly unveil its first service pack for SQL Server 2000 on Monday at the Microsoft TechEd 2001 developer show in Atlanta.

The service pack, which comes 10 months after SQL Server 2000 was released to manufacturing, is not considered a required upgrade. "I can't point to one thing where we say we recommend this is something to fix," says Jeff Ressler, lead product manager for SQL Server 2000. "It's not something that we insist that all customers install."

The service pack includes 240 fixes. About 60 of those address bugs in SQL Server 2000 Analysis Services, the portion of SQL Server 2000 for OLAP and data mining.

Microsoft broke the service pack into three components. A core database component is a 45 MB download, an Analysis Services component is 38.2 MB and a Microsoft Data Engine component is 22.5 MB.

Some tuning in the service pack is specifically for the greater-than-eight-processor machines provided by Unisys Corp., Ressler says. The issue was documented several months ago when SQL Server 2000 achieved certified application status in the Windows 2000 Datacenter Server 2000 certification program. (See story).

The final code for the service pack was posted on Microsoft's TechNet Web site earlier this week, and on Microsoft's SQL Server page late Wednesday.

However, full descriptions for many of the fixes included in SP1 aren't expected to be posted on the site until Monday, Ressler said.

About the Author

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

Featured

  • How To Replace an Aging Domain Controller

    If the hardware behind your domain controllers has become outdated, here's a step-by-step guide to performing a hardware refresh.

  • Azure Backup for SQL Server 2008 Available at Preview Stage

    Microsoft added the option of using the Azure Backup service to provide recovery support for SQL Server 2008 and SQL Server 2008 R2 when those workloads are hosted on Azure virtual machines.

  • Microsoft Suggests Disabling Old Protocols with Exchange Server 2019

    Exchange Server 2019 with Cumulative Update 2 (CU2) can help organizations rid themselves of old authentication protocols, which constitute a potential security risk.

  • Microsoft Previews New Edge Browser on Windows 7 and Windows 8.1

    Microsoft announced this week that it has released previews of its Chromium-based Microsoft Edge Web browsers for use on Windows 7, Windows 8 and Windows 8.1 systems.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.