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

  • Spaceflight Training in the Middle of a Pandemic

    Surprisingly, the worldwide COVID-19 lockdown has hardly slowed down the space training process for Brien. In fact, it has accelerated it.

  • Surface and ARM: Why Microsoft Shouldn't Follow Apple's Lead and Dump Intel

    Microsoft's current Surface flagship, the Surface Pro X, already runs on ARM. But as the ill-fated Surface RT showed, going all-in on ARM never did Microsoft many favors.

  • IT Security Isn't Supposed To Be Easy

    Joey explains why it's worth it to endure a little inconvenience for the long-term benefits of a password manager and multifactor authentication.

  • Microsoft Makes It Easier To Self-Provision PCs via Windows Autopilot When VPNs Are Used

    Microsoft announced this week that the Windows Autopilot service used with Microsoft Intune now supports enrolling devices, even in cases where virtual private networks (VPNs) might get in the way.

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.