remserver-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
@@REMSERVER (Transact-SQL)	@@REMSERVER (Transact-SQL)	MikeRayMSFT	mikeray	09/18/2017	sql	t-sql	reference	@@REMSERVER @@REMSERVER_TSQL	logins [SQL Server], remote servers remote servers [SQL Server], logins @@REMSERVER function	TSQL

@@REMSERVER (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

Important

[!INCLUDEssNoteDepFutureAvoid] This function exists for backward compatibility and always returns NULL. 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.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

@@REMSERVER  

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