SQL Server file names vs versions [closed]

by

The mapping is (along with links to build lists):

Major Version /
Compatibility Level		 Version Label File Version
80 SQL Server 2000 8.00.xxxx
90 SQL Server 2005 9.00.xxxx
100 SQL Server 2008 10.00.xxxx
105 SQL Server 2008 R2 10.50.xxxx
110 SQL Server 2012 11.00.xxxx
120 SQL Server 2014 12.00.xxxx
130 SQL Server 2016 13.00.xxxx
140 SQL Server 2017 14.00.xxxx
150 SQL Server 2019 15.00.xxxx
160 SQL Server 2022 16.00.xxxx

However, just because you have a folder with one of these identifiers, does not mean you have a SQL Server instance of that version installed; some folders are laid down by newer versions for backward compatibility reasons, added by Visual Studio and other tools, or are left behind after an instance has been removed or upgraded.

To see what you actually have installed:

  • Go to your start menu, and go to the highest version of “Microsoft SQL Server 20xx” that you have.
  • Under that menu, go to Configuration Tools > SQL Server Configuration Manager.
  • In the SQL Server Services tab, sort the data by Service Type, and for each line item with the type “SQL Server” (not blank, or “SQL Agent”, or any other), right-click the SQL Server portion and select Properties.
  • On the Advanced tab, scroll down, there will be a field called “Version”, and the number there will map to one of the patterns in the 3rd column above.

enter image description here

More Related Contents:

  1. Updating image in VB and SQL Server not working [closed]
  2. If condition in SQL Server 2008
  3. Compare the values of column in SQL Server
  4. Comma separated results in SQL
  5. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  6. Which are more performant, CTE or temporary tables?
  7. Search all tables, all columns for a specific value SQL Server [duplicate]
  8. When/Why to use Cascading in SQL Server?
  9. SQL WHERE.. IN clause multiple columns
  10. How to add xml encoding to xml Output in SQL Server
  11. What are the differences between a clustered and a non-clustered index?
  12. Unable to begin a distributed transaction
  13. Can you call a webservice from TSQL code?
  14. Difference between #temptable and ##TempTable?
  15. Bulk insert with text qualifier in SQL Server
  16. How to safely use reserved SQL names?
  17. SQL Server: the maximum number of rows in table [closed]
  18. How to migrate a PostgreSQL database into a SQLServer one?
  19. Multiple Column Pivot in T-SQL
  20. SSRS report definition is newer than Server
  21. Compute MD5 hash of a UTF8 string
  22. Sort Bullets in Database
  23. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  24. SQL SERVER PIVOT table with joins and dynamic columns
  25. Generate table relationship diagram from existing schema (SQL Server) [closed]
  26. How does SQL Server decide format for implicit datetime conversion?
  27. Error converting data types when importing from Excel to SQL Server 2008
  28. EAV over SQL Server
  29. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?
  30. The Best Way to shred XML data into SQL Server database columns

Leave a Comment