Search notes:
SQL Server function: serverproperty
select
serverproperty('BuildClrVersion' ) BuildClrVersion,
serverproperty('Collation' ) Collation,
serverproperty('CollationID' ) CollationID,
serverproperty('ComparisonStyle' ) ComparisonStyle,
serverproperty('ComputerNamePhysicalNetBIOS' ) ComputerNamePhysicalNetBIOS,
serverproperty('Edition' ) Edition,
serverproperty('EditionID' ) EditionID,
serverproperty('EngineEdition' ) EngineEdition,
serverproperty('FilestreamShareName' ) FilestreamShareName,
serverproperty('FilestreamConfiguredLevel' ) FilestreamConfiguredLevel,
serverproperty('FilestreamEffectiveLevel' ) FilestreamEffectiveLevel,
serverproperty('HadrManagerStatus' ) HadrManagerStatus,
serverproperty('InstanceDefaultLogPath' ) InstanceDefaultLogPath,
serverproperty('InstanceName' ) InstanceName,
serverproperty('IsAdvancedAnalyticsInstalled' ) IsAdvancedAnalyticsInstalled,
serverproperty('IsClustered' ) IsClustered,
serverproperty('IsFullTextInstalled' ) IsFullTextInstalled,
serverproperty('IsHadrEnabled' ) IsHadrEnabled,
serverproperty('IsIntegratedSecurityOnly' ) IsIntegratedSecurityOnly,
serverproperty('IsLocalDB' ) IsLocalDB,
serverproperty('IsPolybaseInstalled' ) IsPolybaseInstalled,
serverproperty('IsSingleUser' ) IsSingleUser,
serverproperty('IsXTPSuported' ) IsXTPSuported,
serverproperty('LCID' ) LCID,
serverproperty('LicenseType' ) LicenseType,
serverproperty('MachineNmae' ) MachineNmae,
serverproperty('NumLicenses' ) NumLicenses,
serverproperty('ProcessID' ) ProcessID,
serverproperty('ProductBuild' ) ProductBuild,
serverproperty('ProductBuildType' ) ProductBuildType,
serverproperty('ProductLevel' ) ProductLevel,
serverproperty('ProductMajorVersion' ) ProductMajorVersion,
serverproperty('ProductMinorVersion' ) ProductMinorVersion,
serverproperty('ProductUpdateLevel' ) ProductUpdateLevel,
serverproperty('ProductUpdateReference' ) ProductUpdateReference,
serverproperty('ProductVersion' ) ProductVersion,
serverproperty('ResourceLastUpdateDateTime' ) ResourceLastUpdateDateTime,
serverproperty('ResourceVersion' ) ResourceVersion,
serverproperty('ServerName' ) ServerName, -- @@serverName
serverproperty('SqlCharSet' ) SqlCharSet,
serverproperty('SqlCharSetName' ) SqlCharSetName,
serverproperty('SqlSortOrder' ) SqlSortOrder,
serverproperty('SqlSortOrderName' ) SqlSortOrderName
go
InstanceDefaultLogPath
serverproperty('InstanceDefaultLogPath') returns the path to the
instance log file.
InstanceName
serverproperty('InstanceName') returns the
instance name if it is queried on a
named instance. On a
default instance, it returns
NULL.
ProcessID
serverproperty('ProcessID') helps to identify which
sqlsrvr.exe process is related to an
instance.
ServerName
serverproperty('ServerName') returns the string that is needed to connect to an
instance.