Home Forums SQL Server 2005 Administering @@servername and serverproperty('servername') gives different values RE: @@servername and serverproperty('servername') gives different values

  • August 21, 2008 at 6:50 am

    #861198

    It looks like this is Instance name.Did you reinstalled the server?

    The ServerName property provides the Windows NT server and instance name that together make up the unique server instance. @@SERVERNAME provides the currently configured local server name.

    ServerName property and @@SERVERNAME return the same information if the default server name at the time of installation has not been changed.