There are currently four editions being used in industry for various environments -
- SQL Server Enterprise Edition
- SQL Server Standard Edition
- SQL Server Developer Edition
- 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