Tuesday, January 22, 2008

SQL Server Version Numbers - That @@version number means my SQL Server is running what SP?

UK Microsoft Dynamics Support Team Blog - All you need to know about SQL Server build numbers:

"... The easiest way to establish the SQL Server build number is to simply run the following TSQL statement and include the result with any Service Request placed with Microsoft: SELECT @@VERSION.

The result will look something like this:

Microsoft SQL Server 2005 - 9.00.3200.00 (Intel X86)   Oct  2 2007 11:33:27   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

In fact, the only part we need to know from the above information is the number in bold, ie: 9.00.3200.00. ...



See the following KB article for more details about recent SQL Server version history: http://support.microsoft.com/kb/937137/en-us


I was looking for this SQL Server Build/Version Number to SP mapping just yesterday (and I found it, but not nearly in as clear a manner as the above image)...

No comments: