SQL Server Difference between @@SERVERNAME and SERVERPROPERTY(‘SERVERNAME’)

Its general understanding that SQL Server Difference between @@SERVERNAME and SERVERPROPERTY(‘SERVERNAME’) will return same values. But once I got a different values for both Select @@SERVERNAME Select SERVERPROPERTY(‘SERVERNAME’) were returning different …

SQL Server Difference between @@SERVERNAME and SERVERPROPERTY(‘SERVERNAME’) Read More