Recently referenced the Maximum Capacity Specifications for SQL Server information. The link provides information for SQL Server 2008 R2, 2008, 2005, and Denali.
SQL Server Versions
Wednesday, September 7, 2011Update 27-Oct-2011
Found more recent build information on SQLSecurity.com and sqlserverbuilds.blogspot.com.
********************************************
Found this helpful information regarding SQL Server versions and service packs from Bill Graziano on SQLTeam.com. Posting the SQL Server 2008 R2 information for my future reference, however Bill lists this and prior SQL server versions as well.
| SQL Server 2008 R2 | ||
| 10.50.1765.0 | SQL Server 2008 R2 CU6 | 21 Feb 2011 |
| 10.50.1753.0 | SQL Server 2008 R2 CU5 | 20 Dec 2010 |
| 10.50.1746.0 | SQL Server 2008 R2 CU4 | 18 Oct 2010 |
| 10.50.1734.0 | SQL Server 2008 R2 CU3 | 17 Aug 2010 |
| 10.50.1720.0 | SQL Server 2008 R2 CU2 | 25 Jun 2010 |
| 10.50.1702.0 | SQL Server 2008 R2 CU1 | 18 May 2010 |
| 10.50.1600.1 | SQL Server 2008 R2 RTM | 12 Apr 2010 |
Windows OS Versions
Thursday, September 1, 2011Recently been referring to this information in the MSDN library. Decided to post in my blog for easy reference in the future.
| Operating system | Version number |
|---|---|
| Windows 7 | 6.1 |
| Windows Server 2008 R2 | 6.1 |
| Windows Server 2008 | 6.0 |
| Windows Vista | 6.0 |
| Windows Server 2003 R2 | 5.2 |
| Windows Server 2003 | 5.2 |
| Windows XP 64-Bit Edition | 5.2 |
| Windows XP | 5.1 |
| Windows 2000 | 5.0 |
Posted by mrothouse