Retrieve Server Name and Instance from MS SQL Server (TSQL)

February 6, 2018 Ricky Adams

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