servername-transact-sql.md

title	@@SERVERNAME (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	09/17/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.service
ms.component	t-sql|functions
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	@@SERVERNAME @@SERVERNAME_TSQL
dev_langs	TSQL
helpviewer_keywords	@@SERVERNAME function local servers [SQL Server]
ms.assetid	b0ef33fb-954a-4294-b05b-a87c14ce25a3
caps.latest.revision	34
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Active

@@SERVERNAME (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Returns the name of the local server that is running [!INCLUDEssNoVersion].

[!INCLUDEssMIlimitation]

Transact-SQL Syntax Conventions

Syntax

  
@@SERVERNAME  

Return Types

nvarchar

Remarks

[!INCLUDEssNoVersion] Setup sets the server name to the computer name during installation. To change the name of the server, use sp_addserver, and then restart [!INCLUDEssNoVersion].

With multiple instances of [!INCLUDEssNoVersion] installed, @@SERVERNAME returns the following local server name information if the local server name has not been changed since set up.

Instance	Server information
Default instance	'servername'
Named instance	'servername\instancename'
fail over clustered instance - default instance	'virtualservername'
fail over clustered instance - named instance	'virtualservername\instancename'

Although the @@SERVERNAME function and the SERVERNAME property of SERVERPROPERTY function may return strings with similar formats, the information can be different. The SERVERNAME property automatically reports changes in the network name of the computer.

In contrast, @@SERVERNAME does not report such changes. @@SERVERNAME reports changes made to the local server name using the sp_addserver or sp_dropserver stored procedure.

Examples

The following example shows using @@SERVERNAME.

SELECT @@SERVERNAME AS 'Server Name'  

Here is a sample result set.

Server Name  
---------------------------------  
ACCTG  
  

See Also

Configuration Functions (Transact-SQL)
SERVERPROPERTY (Transact-SQL)
sp_addserver (Transact-SQL)