Cumulative Updates for SQL Server 2005 are available

Last week Microsoft snuck in some updates for the SQL Server 2005 product line.  Cumulative Update #7 for Service Pack 3 brings you to build # 9.00.4273, while Cumulative Update #17 for Service Pack 2 brings you to 9.00.3356.  The only fix for the latter involves MDX queries, so if you aren't using Analysis Services, you aren't getting much — if you're still on SP2, then perhaps it is time to move to the SP3 line, where this round of cumulative updates bring you no less than 23 fixes.

KB #976951 : Cumulative update package 7 for SQL Server 2005 Service Pack 3

KB #976952 : Cumulative update package 17 for SQL Server 2005 Service Pack 2

If you are using Analysis Services and you are in the SP3 branch (at CU #6), you will want to apply CU #7.  For more information see this blog post and KB #978145.

Also, if you have any interest in seeing one last service pack for SQL Server 2005 (SP4), go vote for Steve Jones' Connect item #522122!

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

2 Responses

  1. AaronBertrand says:

    IL, occasionally there are fixes that affect the client tools, though usually it is the plumbing and "behind the scenes" code as opposed to visual differences you will see directly.  As a general rule, I've made it a habit to patch my client machines as part of the first round of any patch (we start with client machines and dev/test/qa, then production).

  2. IL says:

    It is interesting to know if these cumulative updates are useful for management tools installed without database engine.