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:
Post a Comment