Search through blog..

Monday, November 2, 2015

How to identify the SQL Version and SQL Edition

When working on AX implementations, one main purpose of Analysis phase is to identify and estimate the License costs for the Customer. And a major part of the Implementation cost can go into "Purchasing licenses"

During such a scenario, I found some helpful information on how to identify the Microsoft SQL Editions.

If you want to check the SQL Version and/or SQL Edition of the installed product, you can follow the below simple steps:
  1. Connect to the server in which SQL Server is installed.
  2. Open SQL Server Management Studio from Programs/Start. Alternatively you can type 'ssms' in Run.
  3. Connect to the Database
  4. Open a new Query window and paste the below code

    select @@servername
    go
    select @@version
    go
    select serverproperty('edition')
    go


  5. Execute the query


This will result in Three different output/resultset. The first provides you the "Name of the server", second provides you the "Version of Installed SQL" and the third provides you with the "Edition of SQL Server installed".

Couple more examples are as below:







Also you can find more details and Compare Editions, i.e, verify the features supported by different Editions of SQL in this Microsoft link: https://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/overview.aspx 
Post a Comment