News

SQL Server 2008 R2 SP2 Released

Service Pack 2 (SP2) of SQL Server 2008 R2 is now available for download, Microsoft announced Thursday.

Not much seems to have changed since the release of a test preview of SP2 in May, though the final service pack fixes some minor issues. One new addition is an improvement to the "dynamic management view" function. Dynamic management views are used to "return server state information," according to an MSDN library article description.

SP2 is available now to keep various editions of SQL Server 2008 R2 up to date. The editions supported by SP2 range from the lofty Parallel Computing edition to the no-cost Express edition. Microsoft's release notes, available here, point users to the right file to download. Alternatively, SP2 can be accessed via the Microsoft download center.

The no-cost SP2 contains cumulative updates 1 though 5 from the first service pack plus additional hotfixes. As previously reported with the beta, the main issues addressed by SP2 include fixing some format problems with SQL Server reporting services, as well as a batch file caching problem.

A list of the flaws addressed by SP2 can be found in this Knowledge Base article.

About the Author

Kurt Mackie is senior news producer for 1105 Media's Converge360 group.

Featured

  • Report: Cost, Sustainability Drive DaaS Adoption Beyond Remote Work

    Gartner's 2025 Magic Quadrant for Desktop as a Service reveals that while secure remote access remains a key driver of DaaS adoption, a growing number of deployments now focus on broader efficiency goals.

  • Windows 365 Reserve, Microsoft's Cloud PC Rental Service, Hits Preview

    Microsoft has launched a limited public preview of its new "Windows 365 Reserve" service, which lets organizations rent cloud PC instances in the event their Windows devices are stolen, lost or damaged.

  • Hands-On AI Skills Now Outshine Certs in Salary Stakes

    For AI-related roles, employers are prioritizing verifiable, hands-on abilities over framed certificates -- and they're paying a premium for it.

  • Roadblocks in Enterprise AI: Data and Skills Shortfalls Could Cost Millions

    Businesses risk losing up to $87 million a year if they fail to catch up with AI innovation, according to the Couchbase FY 2026 CIO AI Survey released this month.