Loading

Important Server Property in SQL Server

Om Agarwal

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')

Comments

Join the conversation! Your thoughts help the community grow.

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