SQL Server 2005/2008 – How to know which are the latest builds available?

First published on MSDN on Jul 01, 2009

Hi,

It is very common to have doubts about the last build or the latest Cumulative Update available for SQL Server 2005 and 2008. These two tables represent the actual situation (1/7/2009):

SQL Server 2005

Supported Build	Last Cumulative Update	KB article	Support Lifecycle
SP2	14	http://support.microsoft.com/kb/970278/	http://support.microsoft.com/lifecycle/?p1=2855
SP3	4	http://support.microsoft.com/kb/970279/	http://support.microsoft.com/lifecycle/?p1=2855

SQL Server 2008

Supported Build	Last Cumulative Update	KB article	Support Lifecycle
RTM	5	http://support.microsoft.com/kb/969531/en-us	http://support.microsoft.com/lifecycle/?p1=13165
SP1	2	http://support.microsoft.com/kb/970315/en-us	http://support.microsoft.com/lifecycle/?p1=13165

These KB articles can be used to know the latest builds publicly available for SQL Server 2005 (SP2 and SP3) / 2008 (RTM and SP1):

The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released

http://support.microsoft.com/kb/937137/

The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released

http://support.microsoft.com/kb/960598/

The SQL Server 2008 builds that were released after SQL Server 2008 was released

http://support.microsoft.com/kb/956909/

The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released

http://support.microsoft.com/kb/970365/

My recommendation is that you subscribe this RSS Feed to get a notification every time that a new Cumulative Update or Service Pack is released:

http://blogs.msdn.com/sqlreleaseservices/archive/2009/06/15/cumulative-update-4-for-sql-server-2005-service-pack-3.aspx

Cheers,