SQL Server version information from build numbers

Just a quick post in case anyone else finds this useful; for a report I’ve created, I wanted to have SQL Server versions displayed in a nice, readable form, rather than the usual build number format (e.g. 11.0.3128.0).

Server dashboard report

So I found the very useful SQL Server Builds page (thanks to whoever maintains that), and proceeded to write a function which accepts the build number, and spits out a friendlier “version string”, down to the service pack and cumulative update level of resolution. (I didn’t need anything lower than that, but you could easily add it in yourself).

Here’s the file, feel free to download, use, hack to pieces, etc. 😉



1 thought on “SQL Server version information from build numbers”

  1. Nice function. I use a different method that doesn’t provide the CU level but is not relevant in my case.

    IF OBJECT_ID(‘dbo.sp_Get_SQL_Version_Text’) IS NOT NULL
    DROP PROCEDURE dbo.sp_Get_SQL_Version_Text;
    Who : Matthew Hill
    When : 2012-05-01
    What : Outputs SQL version and SP version e.g. 2008 R2 SP1
    CREATE PROCEDURE dbo.sp_Get_SQL_Version_Text

    declare @ver nvarchar(32)
    set @ver = cast((select SERVERPROPERTY(‘productversion’)) as nvarchar)
    when @ver like ‘9.%’ then ‘2005’
    when @ver like ‘10.0.%’ then ‘2008’
    when @ver like ’10.[^0]%’ then ‘2008 R2′
    when @ver like ’11.%’ then ‘2012’
    when @ver like ’11.[^0]%’ then ‘2012 R2’

    END + ‘ ‘ + CAST(SERVERPROPERTY (‘productlevel’) as nvarchar(20)) + ‘ (‘ + @ver + ‘)’


Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top