SERVERPROPERTY of Sql Sever

SELECT SERVERPROPERTY('productversion')

SELECT SERVERPROPERTY ('productlevel')

SELECT SERVERPROPERTY ('edition')

SELECT SERVERPROPERTY('ServerName')

SELECT SERVERPROPERTY ('ProcessID')

SELECT SERVERPROPERTY ('NumLicenses')

SELECT SERVERPROPERTY('MachineName')

SELECT SERVERPROPERTY ('LicenseType')

SELECT SERVERPROPERTY ('IsSyncWithBackup')

SELECT SERVERPROPERTY('IsSingleUser')

SELECT SERVERPROPERTY ('IsIntegratedSecurityOnly')

SELECT SERVERPROPERTY ('IsFullTextInstalled')

SELECT SERVERPROPERTY('IsClustered')

SELECT SERVERPROPERTY ('InstanceName')

SELECT SERVERPROPERTY ('Engine Edition')

SELECT SERVERPROPERTY('Collation')