How do I view the version, Patch pack information for SQL Server? And how do I identify if I need to upgrade my SQL Server?

As a database administrator of SQL Server, one of the most frequently encountered problems is to see which version of SQL Server you belong to, whether the latest fix pack is installed, and whether the most recent security patches are installed. Prior to this, we could get the relevant information through the following SQL script:

Method 1:select @ @version//Method 2:selectserverproperty (' ProductLevel ') as Productlevel,serverproperty (' Productupdatelevel ') as Productupdatelevel,serverproperty (' Productbuildtype ') as Productbuildtype,serverproperty (' Productupdatereference ') as Productupdatereference,serverproperty (' ProductVersion ') as ProductVersion, Serverproperty (' productmajorversion ') as Productmajorversion,serverproperty (' productminorversion ') as Productminorversion,serverproperty (' Productbuild ') as Productbuildgo

Then go to Microsoft's official website KB321185 The version information in the comparison, so as to determine whether to update the database upgrade. At present, Microsoft's one script team released a SQL script, the administrator directly run the script, you can get the following results:

SQL Server belongs to which release, which version, which service pack, which integration fix pack, and so on. At the same time, the most important thing is that it will give you advice on which recent patch package you should install and which Servcie pack you should upgrade to.

You can download and use this script from TechNet as one of your own tools for managing your database server on a daily basis:

• : Https://gallery.technet.microsoft.com/Determining-which-version-af0f16f6/file/144559/1/DetermineVersionOfSQLServer.zip
• Article Address: Https://gallery.technet.microsoft.com/Determining-which-version-af0f16f6

How do I view the version, Patch pack information for SQL Server? And how do I identify if I need to upgrade my SQL Server?