Code to get information about license mode, sp level and other useful info

select serverproperty('COLLATION')AS COLLATION, serverproperty('Edition') AS EDITION,
serverproperty('InstanceName') AS INSTANCENAME, serverproperty('IsClustered') AS ISCLUSTeRED,
serverproperty('IsFullTextInstalled') AS ISFULLTEXTINSTALLED,
serverproperty('IsIntegratedSecurityOnly') AS ISINTEGRATEDSECURITYONLY,
serverproperty('IsSingleUser') AS ISSINGLEUSER, serverproperty('LicenseType') AS LICENSETYPE,
serverproperty('MachineName') AS MACHINENAME, serverproperty('NumLicenses') AS NUMLICENSES,
serverproperty('ProcessID') AS PROCESSID, serverproperty('ProductVersion') AS PRODUCTVERSION,
serverproperty('ProductLevel') AS PRODUCTLEVEL, serverproperty('ServerName') AS SERVERNAME