SQL SERVER – Versions, CodeNames, Year of Release

Just a day ago, while I was discussing one of the project with another outsourcing team lead in India (who is leading team of 100+ programmer and developer) he asked me if I know all the codenames of the SQL Server releases so far. I knew only two code names SQL Server 2005 – Yukon and SQL Server 2008 – Katmai. Once our meeting was over, I could not stop thinking about this question. I search online and very easily I found answer to this question on wikipedia.

  • 1993 – SQL Server 4.21 for Windows NT
  • 1995 – SQL Server 6.0, codenamed SQL95
  • 1996 – SQL Server 6.5, codenamed Hydra
  • 1999 – SQL Server 7.0, codenamed Sphinx
  • 1999 – SQL Server 7.0 OLAP, codenamed Plato
  • 2000 – SQL Server 2000 32-bit, codenamed Shiloh (version 8.0)
  • 2003 – SQL Server 2000 64-bit, codenamed Liberty
  • 2005 – SQL Server 2005, codenamed Yukon (version 9.0)
  • 2008 – SQL Server 2008, codenamed Katmai (version 10.0)
  • 2011 – SQL Server 2008, codenamed Denali (version 11.0)

SQL Server 2008 is expected to be release in February 2008.

UPDATE (Oct 2012). SQL Server 2012 was released in April 2012 and the codename of the product is “Denali.”

Reference : Pinal Dave (http://blog.SQLAuthority.com), Wikipedia – SQL Server

About these ads

SQL SERVER – 2005 – Version Information and Additional Information – Extended Stored Procedure xp_msver

I was glad when I discovered this Extended Stored Procedure myself. I always used different syntax to retrieve server information. Many of information I was looking up using system information of the windows operating system.

Syntax:
EXEC xp_msver
ResultSet:
Index Name Internal_Value Character_Value
—— ——————————– ————– ————————————-
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 589824 9.00.3042.00
3 Language 1033 English (United States)
4 Platform NULL NT INTEL X86
5 Comments NULL NT INTEL X86
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT
8 FileVersion NULL 2005.090.3042.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL © Microsoft Corp. All rights reserved.
11 LegalTrademarks NULL Microsoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 199360512 NULL
15 WindowsVersion 170393861 5.1 (2600)
16 ProcessorCount 1 1
17 ProcessorActiveMask 1 00000001
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 1023 1023 (1073111040)
20 Product ID NULL NULL

Watch a 60 second video on this subject

Reference : Pinal Dave (http://blog.SQLAuthority.com), BOL