remserver-transact-sql.md

description	@@REMSERVER (Transact-SQL)
title	@@REMSERVER (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	09/18/2017
ms.prod	sql
ms.prod_service	sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	reference
f1_keywords	@@REMSERVER @@REMSERVER_TSQL
dev_langs	TSQL
helpviewer_keywords	logins [SQL Server], remote servers remote servers [SQL Server], logins @@REMSERVER function
ms.assetid	0bb451a9-3866-4064-963d-b74a2f864049
author	julieMSFT
ms.author	jrasnick

@@REMSERVER (Transact-SQL)

[!INCLUDE SQL Server]

Important

[!INCLUDEssNoteDepNextDontUse] Use linked servers and linked server stored procedures instead.

Returns the name of the remote [!INCLUDEssNoVersion] database server as it appears in the login record.

Transact-SQL Syntax Conventions

Syntax

@@REMSERVER  

[!INCLUDEsql-server-tsql-previous-offline-documentation]

Return Types

nvarchar(128)

Remarks

@@REMSERVER enables a stored procedure to check the name of the database server from which the procedure is run.

Examples

The following example creates the procedure usp_CheckServer that returns the name of the remote server.

CREATE PROCEDURE usp_CheckServer  
AS  
SELECT @@REMSERVER;  

The following stored procedure is created on the local server SEATTLE1. The user logs on to a remote server, LONDON2, and runs usp_CheckServer.

EXEC SEATTLE1...usp_CheckServer;  

[!INCLUDEssResult]

---------------  
LONDON2  

See Also

Configuration Functions (Transact-SQL)
Remote Servers