List of SQL Server 2005 post-SP2 builds

For years, ever since I started posting build lists over at (don't go there now; it's been taken over by malware slimeballs), I have been complaining that Microsoft makes it very hard for us to stay on top of these things, and suggested on numerous occasions that they publish a list of builds that have been released, even if only through support cases.

Well, it looks like they're finally listening.  Here is a list of all of the builds that have been released for SQL Server 2005, since service pack 2:

Now what I would suggest next is that whenever they create a summary KB article like this, they place it somewhere prominent (e.g. on the service pack x download page).  This way, people don't have to know to take it upon themselves to go search for post-SP builds that will fix any unexpected problems that the service pack itself introduces (I'll give you a hint: sounds like "tainted Jets fans").

So, people who have been painstakingly keeping track of builds manually (myself on this blog, and others like, it seems like we have much less work cut out for us in the future.  The main problem is that it's impossible to keep updating our own blog entries or reference sites, especially during periods of high activity for the build team (currently we're not in one of those).  Hopefully they will keep improving the usability of the site and figure out a way to make these lists of builds more prominent and easier to find… more importantly, easier to figure out that we need to look for them.

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 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. :-)

6 Responses

  1. Jesssica says:

    Microsoft KB article 937137 has a list of all the post SP2 builds for SQL Server 2005. The most current build is 3182, released on July 17.Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2005 fix release. SQL Server 2005 hotfixes are now multilanguage. There is only one cumulative update package for all languages. You must apply a SQL Server 2005 Service Pack 2 hotfix to an installation of SQL Server 2005 Service Pack 2. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack.
    <a href="; rel="dofollow">Link Building</a>

  2. jerryhung says:

    I agree, even Microsoft itself may not have all the builds in one place
    Anyway, good thing I don't need to check versions/builds that often
    In fact, we are still on SP1 due to many issues from SP2, even less confusion
    so mostly I only see 9.00.1399 (RTM) or 9.00.2047 (SP1)

  3. AaronBertrand says:

    Yes Jerry, but part of my point is that no external source can ever be complete, and it is very cumbersome for end users to make it so.  The site you point out, for example, is missing 3203, 3205, 3206, etc. etc.

  4. sequal guy says:

    I have each and every version/patch number for sql server from 6.5 to 2008 patch.
    email me at [email protected] if anyone wants it

  5. sequal guy says:

    I have each and every version/patch number for sql server from 6.5 to 2008 patch.
    email me at [email protected] if anyone wants it

  6. jerryhung says:

    I use this site to tell the builds quickly