SELECT SERVERPROPERTY('ServerName')
SELECT SERVERPROPERTY('MachineName')
SELECT @@SERVERNAME
SELECT HOST_NAME()