SQL Server Build and Version

I was working on a project to identify all the versions of SQL Servers in our environment with Service packs etc. and propose a solution to manage the SQL Servers efficiently. By the nature of SQL Server, it’s not too helpful to identify the version from the Help button of Management Studio. It displays a version/build number which was not helpful in my case.

I ran the following script which is quite helpful if you want to get info like the Product Version, Product Level, and Editions of SQL Server.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')