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')
No comments:
Post a Comment