Filenames by Version in SQL Server
In this article, I will provide information about finding filenames by version in SQL Server.
In SQL Server, in some cases we may want to know which version of SQL Server is installed based on the file name.
With the help of the information below, you can easily learn the version information.
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
You will see the information you see above in the directory where SQL Server is installed. For example, SQL Server 2014 is installed on my computer and I understand this from the folder structure below.
As you can see, it says 12 next to the file. This shows us the version. So I am using SQL Server 2014.
Good luck to everyone in business and life.