Labels

Monday, 7 December 2015

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

There are several ways to find out tge 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

No comments:

Post a Comment