SELECT SERVERPROPERTY('MachineName') val ,'Machine Name' Descr UNION ALL select SERVERPROPERTY('ServerName') ,'Server Name' UNION ALL select SERVERPROPERTY('InstanceName') , 'Instance' UNION ALL select SERVERPROPERTY('IsClustered') , 'IsClustered' UNION ALL select SERVERPROPERTY('ComputerNamePhysicalNetBIOS') , 'Computer Name Physical NetBIOS' UNION ALL select SERVERPROPERTY('Edition') , 'Edition' UNION ALL select SERVERPROPERTY('ProductLevel') , 'Product Level (What servicing branch (RTM/SP/CU))' UNION ALL select SERVERPROPERTY('ProductUpdateLevel') , 'Product Update Level (Within a servicing branch, what CU# is applied)' UNION ALL select SERVERPROPERTY('ProductVersion') , 'Product Version' UNION ALL select SERVERPROPERTY('ProductMajorVersion') , 'Product Major Version' UNION ALL select SERVERPROPERTY('ProductMinorVersion') , 'Product Minor Version' UNION ALL select SERVERPROPERTY('ProductBuild') , 'Product Build' UNION ALL select SERVERPROPERTY('ProductBuildType') , 'Product Build Type ( Is this a GDR or OD hotfix (NULL if on a CU build))' UNION ALL select SERVERPROPERTY('ProductUpdateReference') , 'Product Update Reference (KB article number that is applicable for this build)' UNION ALL select SERVERPROPERTY('ProcessID') , 'ProcessID' UNION ALL select SERVERPROPERTY('Collation') , 'Collation' UNION ALL select SERVERPROPERTY('IsFullTextInstalled') , 'IsFullTextInstalled' UNION ALL select SERVERPROPERTY('IsIntegratedSecurityOnly') , 'IsIntegratedSecurityOnly' UNION ALL select SERVERPROPERTY('FilestreamConfiguredLevel') , 'FilestreamConfiguredLevel' UNION ALL select SERVERPROPERTY('IsHadrEnabled') , 'IsHadrEnabled' UNION ALL select SERVERPROPERTY('HadrManagerStatus') , 'HadrManagerStatus' UNION ALL select SERVERPROPERTY('InstanceDefaultDataPath') , 'InstanceDefaultDataPath' UNION ALL select SERVERPROPERTY('InstanceDefaultLogPath') , 'InstanceDefaultLogPath' UNION ALL select SERVERPROPERTY('BuildClrVersion') , 'Build CLR Version' UNION ALL select SERVERPROPERTY('IsXTPSupported') , 'IsXTPSupported' UNION ALL select SERVERPROPERTY('IsPolybaseInstalled') , 'IsPolybaseInstalled' UNION ALL select SERVERPROPERTY('IsAdvancedAnalyticsInstalled') , 'IsRServicesInstalled'
1 thought on “Get Server properties”
Comments are closed.
Pingback: Find Server property using TSQL code Himanshu Patel SQL Server Consultant developer & Administrator -