Find the name of SQL Server

select serverproperty (‘MachineName’) as Servername

SELECT SERVERPROPERTY(‘ServerName’) AS ServerName

Select SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) as PhysicalName

SELECT @@SERVERNAME AS ServerNameGlobalVar

Comments are closed.