Usually when taking over a new position as DBA, or when discovering a new server in your existing environment, you need to determine what version of SQ Server is installed. This can be accomplished in a few different ways.
By using SQL Server Management Studio (SSMS) and right clicking on the instance name, you can display the properties of the instance selected. In the general section, you will see the relevant information such as version. The “Version” value gives you a specific version number that is installed.
This will return the version of the product installed.
You can also locate the installation folder in the Windows Explorer, and right-click on the sqlservr.exe to display the properties as you would any other file. The displayed properties will also display the version of the executable, which should also match the standard version numbers you might expect to see from within SQL Server.
SQL Server Versions
The general version numbers can be matched to the major versions of SQL Server, but the specific version numbers are important to see what updates or patches are installed.
- 8.0 for SQL Server 2000
- 9.0 for SQL Server 2005
- 10.0 for SQL Server 2008
- 10.5 for SQL Server 2008 R2
- 11.0 for SQL Server 2012
- 12.0 for SQL Server 2014
- 13.0 for SQL Server 2016