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