Updated for SQL Server 2025.
SELECT 'BuildClrVersion' ,SERVERPROPERTY(N'BuildClrVersion') UNION ALL SELECT 'Collation' ,SERVERPROPERTY(N'Collation') UNION ALL SELECT 'CollationID' ,SERVERPROPERTY(N'CollationID') UNION ALL SELECT 'ComparisonStyle' ,SERVERPROPERTY(N'ComparisonStyle') UNION ALL SELECT 'ComputerNamePhysicalNetBIOS' ,SERVERPROPERTY(N'ComputerNamePhysicalNetBIOS') UNION ALL SELECT 'Edition' ,SERVERPROPERTY(N'Edition') UNION ALL SELECT 'EditionID' ,SERVERPROPERTY(N'EditionID') UNION ALL SELECT 'EngineEdition' ,SERVERPROPERTY(N'EngineEdition') UNION ALL SELECT 'FilestreamConfiguredLevel' ,SERVERPROPERTY(N'FilestreamConfiguredLevel') UNION ALL SELECT 'FilestreamEffectiveLevel' ,SERVERPROPERTY(N'FilestreamEffectiveLevel') UNION ALL SELECT 'FilestreamShareName' ,SERVERPROPERTY(N'FilestreamShareName') UNION ALL SELECT 'HadrManagerStatus' ,SERVERPROPERTY(N'HadrManagerStatus') UNION ALL SELECT 'InstanceDefaultBackupPath' ,SERVERPROPERTY(N'InstanceDefaultBackupPath') UNION ALL SELECT 'InstanceDefaultDataPath' ,SERVERPROPERTY(N'InstanceDefaultDataPath') UNION ALL SELECT 'InstanceDefaultLogPath' ,SERVERPROPERTY(N'InstanceDefaultLogPath') UNION ALL SELECT 'InstanceName' ,SERVERPROPERTY(N'InstanceName') UNION ALL SELECT 'IsAdvancedAnalyticsInstalled' ,SERVERPROPERTY(N'IsAdvancedAnalyticsInstalled') UNION ALL SELECT 'IsBigDataCluster' ,SERVERPROPERTY(N'IsBigDataCluster') UNION ALL SELECT 'IsClustered' ,SERVERPROPERTY(N'IsClustered') UNION ALL SELECT 'IsExternalAuthenticationOnly' ,SERVERPROPERTY(N'IsExternalAuthenticationOnly') UNION ALL SELECT 'IsExternalGovernanceEnabled' ,SERVERPROPERTY(N'IsExternalGovernanceEnabled') UNION ALL SELECT 'IsFullTextInstalled' ,SERVERPROPERTY(N'IsFullTextInstalled') UNION ALL SELECT 'IsHadrEnabled' ,SERVERPROPERTY(N'IsHadrEnabled') UNION ALL SELECT 'IsIntegratedSecurityOnly' ,SERVERPROPERTY(N'IsIntegratedSecurityOnly') UNION ALL SELECT 'IsLocalDB' ,SERVERPROPERTY(N'IsLocalDB') UNION ALL SELECT 'IsPolyBaseInstalled' ,SERVERPROPERTY(N'IsPolyBaseInstalled') UNION ALL SELECT 'IsServerSuspendedForSnapshotBackup' ,SERVERPROPERTY(N'IsServerSuspendedForSnapshotBackup') UNION ALL SELECT 'IsSingleUser' ,SERVERPROPERTY(N'IsSingleUser') UNION ALL SELECT 'IsTempDbMetadataMemoryOptimized' ,SERVERPROPERTY(N'IsTempDbMetadataMemoryOptimized') UNION ALL SELECT 'IsXTPSupported' ,SERVERPROPERTY(N'IsXTPSupported') UNION ALL SELECT 'LCID' ,SERVERPROPERTY(N'LCID') UNION ALL SELECT 'LicenseType' ,SERVERPROPERTY(N'LicenseType') UNION ALL SELECT 'MachineName' ,SERVERPROPERTY(N'MachineName') UNION ALL SELECT 'NumLicenses' ,SERVERPROPERTY(N'NumLicenses') UNION ALL SELECT 'PathSeparator' ,SERVERPROPERTY(N'PathSeparator') UNION ALL SELECT 'ProcessID' ,SERVERPROPERTY(N'ProcessID') UNION ALL SELECT 'ProductBuild' ,SERVERPROPERTY(N'ProductBuild') UNION ALL SELECT 'ProductBuildType' ,SERVERPROPERTY(N'ProductBuildType') UNION ALL SELECT 'ProductLevel' ,SERVERPROPERTY(N'ProductLevel') UNION ALL SELECT 'ProductMajorVersion' ,SERVERPROPERTY(N'ProductMajorVersion') UNION ALL SELECT 'ProductMinorVersion' ,SERVERPROPERTY(N'ProductMinorVersion') UNION ALL SELECT 'ProductUpdateLevel' ,SERVERPROPERTY(N'ProductUpdateLevel') UNION ALL SELECT 'ProductUpdateReference' ,SERVERPROPERTY(N'ProductUpdateReference') UNION ALL SELECT 'ProductUpdateType' ,SERVERPROPERTY(N'ProductUpdateType') UNION ALL SELECT 'ProductVersion' ,SERVERPROPERTY(N'ProductVersion') UNION ALL SELECT 'ResourceLastUpdateDateTime' ,SERVERPROPERTY(N'ResourceLastUpdateDateTime') UNION ALL SELECT 'ResourceVersion' ,SERVERPROPERTY(N'ResourceVersion') UNION ALL SELECT 'ServerName' ,SERVERPROPERTY(N'ServerName') UNION ALL SELECT 'SqlCharSet' ,SERVERPROPERTY(N'SqlCharSet') UNION ALL SELECT 'SqlCharSetName' ,SERVERPROPERTY(N'SqlCharSetName') UNION ALL SELECT 'SqlSortOrder' ,SERVERPROPERTY(N'SqlSortOrder') UNION ALL SELECT 'SqlSortOrderName' ,SERVERPROPERTY(N'SqlSortOrderName') UNION ALL SELECT 'SuspendedDatabaseCount' ,SERVERPROPERTY(N'SuspendedDatabaseCount');