Applies to: SQL Server (all supported versions) Azure SQL Managed Instance
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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 SQL Server database server as it appears in the login record.
To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
@@REMSERVER enables a stored procedure to check the name of the database server from which the procedure is run.
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
Here is the result set.