[SQL Server] Frequently used ServerProperties

[SQL Server] Frequently used ServerProperties

Returns property Information

SELECT SERVERPROPERTY('MachineName') AS [ServerName], 
       SERVERPROPERTY('ServerName') AS [ServerInstanceName], 
       SERVERPROPERTY('InstanceName') AS [Instance], 
       SERVERPROPERTY('Edition') AS [Edition], 
       SERVERPROPERTY('ProductVersion') AS [ProductVersion], 
       LEFT(@@Version, CHARINDEX('-', @@version) - 2) AS VersionName;

SQL Server 2016

SQL Server 2017

SQL Server 2019

Reference

• SERVERPROPERTY (Transact-SQL)
• https://docs.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-ver15