How to identify version?

  • I have ran into a support task on a pretty huge DB, the backup is 16 GB.
    That will need a developer version to run.

    How to identify which version i have, i.e. express or Developer?

    Best regards

    Edvard Korsbæk

  • To identify the version of SQL Server you are running, try the below statement. Near the end of the output look for "<Developer> Edition (64-bit) on Windows..."

    SELECT @@VERSION
    A Google search on "Identify SQL version" will bring up this and alternate methods of finding this information 🙂.

    Andrew P.

  • Thanks!

    Microsoft SQL Server 2016 (RTM-GDR) (KB4019088) - 13.0.1742.0 (X64) Jul 5 2017 23:41:17 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 6.3 <X64> (Build 17134: )

    And i were both on google and tried to use the search function here to find an answer before this topic btw.
    Google is fantastic, if you know how to phrase your question..

    Best regards

    Edvard Korsbæk

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply