@@REMSERVER (Transact-SQL)

**APPLIES TO:** SQL Server (starting with 2008) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

[!IMPORTANT]
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use linked servers and linked server stored procedures instead.

Returns the name of the remote SQL Server database server as it appears in the login record.

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;  

Here is the result set.

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

See Also

Configuration Functions (Transact-SQL)
Remote Servers