Add as a preferred source on Google


News

Microsoft Delivers SQL Server 2005 SP3

Microsoft ratcheted up its product support for SQL Server 2005 by releasing Service Pack 3 (SP3) on Monday, along with SP3 Cumulative Update 1.

Microsoft ratcheted up its product support for SQL Server 2005 by releasing Service Pack 3 (SP3) on Monday, along with SP3 Cumulative Update 1. On the same day, the company also released Cumulative Update 11 for SQL Server 2005 Service Pack 2 (SP2).

If that weren't enough, the company offered incentives for Microsoft's partners and Microsoft Dynamics customers to jump to SQL Server 2008, which was released as a product last summer.

Microsoft is updating its price list on January 1, 2009 and will replace the runtime for SQL Server 2005 with that of Microsoft SQL Server 2008, according to a Microsoft Dynamics blog.

"Customers who have licensed Microsoft SQL 2008-Runtime and are current on the Business Ready Enhancement Plan as of January 1, 2009 will be entitled to an upgrade to Microsoft SQL Server 2008," the blog explained.

Features in SQL Server SP3 include "supportability enhancements," plus improvements in the database engine, notifications services, replication and reporting services, according to an MSDN library Web page. SP3 contains all previously released cumulative updates for SQL Server 2005.

KnowledgeBase articles for SP3 are available through the release notes here.

For SQL users not opting for SP3, Microsoft released Cumulative Update 11 for SQL Server 2005 SP2, which contains all of the hot fixes for SP2, without the new features in SP3.

However for those who are moving from SQL Server SP2 to SP3, Microsoft offers a caveat. Be sure to apply SP3 Cumulative Update 1.

"If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or from SQL Server 2005 SP2 Cumulative Update 11, you must apply a post-SP3 cumulative update after you upgrade to SP3 to obtain all the fixes," according to Nick MacKechnie's blog.

For those wanting more than just blog advice, Microsoft's "Books Online" release for Microsoft SQL Server 2005 is available here. It provides primary documentation, including setup and upgrade instructions for SP3.

Microsoft also released a new Feature Pack for SQL Server 2008 on Monday that provides optional add-ons for the database solution. The December Feature Pack can be accessed here.

For more information and links to documentation, visit the Swiss IT Professional and TechNet Blog.

About the Author

Herb Torrens is an award-winning freelance writer based in Southern California. He managed the MCSP program for a leading computer telephony integrator for more than five years and has worked with numerous solution providers including HP/Compaq, Nortel, and Microsoft in all forms of media.

Featured

  • Microsoft Dismantles RedVDS Cybercrime Marketplace Linked to $40M in Phishing Fraud

    In a coordinated action spanning the United States and the United Kingdom, Microsoft’s Digital Crimes Unit (DCU) and international law enforcement collaborators have taken down RedVDS, a subscription based cybercrime platform tied to an estimated $40 million in fraud losses in the U.S. since March 2025.

  • Sound Wave Illustration

    CrowdStrike's Acquisition of SGNL Aims to Strengthen Identity Security

    CrowdStrike signs definitive agreement to purchase SGNL, an identity security specialist, in a deal valued at about $740 million.

  • Microsoft Acquires Osmos, Automating Data Engineering inside Fabric

    In a strategic move to reduce time-consuming manual data preparation, Microsoft has acquired Seattle-based startup Osmos, specializing in agentic AI for data engineering.

  • Linux Foundation Unites Major Tech Firms to Launch Agentic AI Foundation

    The Linux Foundation today announced the creation of a new collaborative initiative — the Agentic AI Foundation (AAIF) — bringing together major AI and cloud players such as Microsoft, OpenAI, Anthropic and other major tech companies.

Most   Popular