In this blog We can get significant server property which returns
all information about the SQL Server instance. Use following script to see all
the properties of server instance.
SELECT
'BuildClrVersion' Property,
SERVERPROPERTY('BuildClrVersion')
[Values returned]
UNION
ALL
SELECT
'Collation',
SERVERPROPERTY('Collation')
UNION
ALL
SELECT
'ComputerNamePhysicalNetBIOS',
SERVERPROPERTY('ComputerNamePhysicalNetBIOS')
UNION
ALL
SELECT
'Edition',
SERVERPROPERTY('Edition')
UNION
ALL
SELECT
'EngineEdition',
SERVERPROPERTY('EngineEdition')
UNION
ALL
SELECT
'MachineName',
SERVERPROPERTY('MachineName')
UNION
ALL
SELECT
'ProcessID',
SERVERPROPERTY('ProcessID')
UNION
ALL
SELECT
'ProductVersion',
SERVERPROPERTY('ProductVersion')
UNION
ALL
SELECT
'ResourceLastUpdateDateTime',
SERVERPROPERTY('ResourceLastUpdateDateTime')
UNION
ALL
SELECT
'ResourceVersion',
SERVERPROPERTY('ResourceVersion')
UNION
ALL
SELECT
'ServerName',
SERVERPROPERTY('ServerName')
Output