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
Github repository about-MSSQL, path: /t-sql/functions/serverproperty/select-all.sql

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.
The same value can also be obtained with @@servername.

See also

T-SQL functions

Index