Tag: SQL Server Versions

  • How to check SQL Server Version Or Build No?

    Option 1
    EXEC master..sp_MSgetversion
    Output
    Character_Value
    ——————– ———– ———–
    10.0.2789.0 1 3

    Option 2
    select @@version
    Output
    Microsoft SQL Server 2008 (SP1) – 10.0.2789.0 (X64)
    Jul 12 2010 19:21:29
    Copyright (c) 1988-2008 Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    Option 3
    SELECT SERVERPROPERTY('productversion')
    Output Build Version
    10.0.2789.0

    Option 5
    SELECT SERVERPROPERTY ('productlevel')
    Output-Service Pack
    SP1

    Option 6
    SELECT SERVERPROPERTY ('edition')
    Output-Edition
    Enterprise Edition (64-bit)