Important Server Property in SQL Server

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