DBA - What are SQL Server Versions and Editions available?


There are currently four editions being used in industry for various environments -

  1. SQL Server Enterprise Edition
  2. SQL Server Standard Edition
  3. SQL Server Developer Edition
  4. SQL Server Express Edition

Below are SQL Server versions available along their code names.

Fig 1: SQL Server Version available in Market as of September, 2014.

How to find out what version as well as edition of SQL Server currently running?

There are several ways to find out version of SQL server, below are couple easy way to find currently running version.

Option: 1


  • Open management studio, connect to particular server that you would like to find the information about
  • Open new query and type " Select @@version"
  • Run the query or press F5.

Fig 2: How to find SQL Server Version and Edition by using built in SQL Server Function

Option: 2

  • Open management studio, connect to particular server that you would like to find the information about
  • Right click on the server and go to properties

Fig 1: Find SQL server Version and Edition by using GUI

Fig 4: Get SQL Server Edition and Version Information by using Instance Properties

10 comments:

  1. i am really thank you by providing this good notes to get easily different types of SQL SERVER edition and versions.

    ReplyDelete
  2. Thanks for giving valuable information....

    ReplyDelete
  3. I am so happy to have found this site. I was looking on YT on SQL videos when someone mentioned this site to someone else and when I say pure gold!! I have to keep digging to see how else we can be of gratitude for the straight cut content you have provided for us. God Bless

    ReplyDelete