How to find out the detail of MSSQL server instance

Sometimes it is required to find out the details like product version, edition and

server version of MSSQL server.

Below is the query to find out these detail easily.

SELECT SERVERPROPERTY('LicenseType') as Licensetype,

SERVERPROPERTY('NumLicenses') as LicenseNumber,

SERVERPROPERTY('productversion') as Productverion,

SERVERPROPERTY ('productlevel')as ProductLevel,

SERVERPROPERTY ('edition') as SQLEdition,@@VERSION as SQLversion

Below is the output of query.

I hope you find it useful. Stay tuned for more such updates