| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_remoteoption (Transact-SQL) |
sp_remoteoption displays or changes options for a remote login defined on the local server running SQL Server. |
markingmyname |
maghan |
randolphwest |
08/22/2024 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Displays or changes options for a remote login defined on the local server running [!INCLUDE ssNoVersion].
Note
[!INCLUDE ssNoteDepFutureAvoid]sp_remoteoption doesn't change any options and returns an error message. It's supported for backward compatibility only.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_remoteoption
[ @remoteserver = ] N'remoteserver'
[ , [ @loginame = ] N'loginame' ]
[ , [ @remotename = ] N'remotename' ]
[ , [ @optname = ] 'optname' ]
[ , [ @optvalue = ] 'optvalue' ]
[ ; ]
This stored procedure returns the following error message:
The trusted option in remote login mapping is no longer supported.