SQL SERVER NAME

SELECT @@SERVERNAME

Select * from sysservers where srvid = 0

Select Host_Name() as Computer_Name

EXEC xp_getNetName

SELECT CONVERT(sysname, SERVERPROPERTY(N'servername'))