You can get the MS SQL Server version and edition by executing below command. From the output, you will get the cumulative updates, types, build and support pack version.
Method 1
select @@VERSION;
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2769.0 (X64) Jun 24 2011 13:09:43
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64>
(Build 7601: Service Pack 1) (Hypervisor)
Method 2
Alternatively, you can open the MS SQL Server Management Studio, right click on the database name, choose Properties. You will see the information under the General tab.
Method 3
The same information can also obtain from the ERROR.LOG message.
C:\Program Files\Microsoft SQL Server\[SQL-VERSION-FOLDER\MSSQL\Log
2020-06-28 17:50:26.06 Server Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
Method 4
Use the following command line.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
