sp-remoteoption-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
sp_remoteoption (Transact-SQL)	sp_remoteoption (Transact-SQL)	markingmyname	maghan	03/14/2017	sql	system-objects	reference	sp_remoteoption_TSQL sp_remoteoption	sp_remoteoption	TSQL

sp_remoteoption (Transact-SQL)

[!INCLUDE SQL Server]

Displays or changes options for a remote login defined on the local server running [!INCLUDEssNoVersion].

Note

[!INCLUDEssNoteDepFutureAvoid]sp_remoteoption does not change any options and returns an error message. It is supported for backward compatibility only.

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

Syntax

  
sp_remoteoption [ [ @remoteserver = ] 'remoteserver' ]   
     [ , [ @loginame = ] 'loginame' ]   
     [ , [ @remotename = ] 'remotename' ]   
     [ , [ @optname = ] 'optname' ]   
     [ , [ @optvalue = ] 'optvalue' ]  

Remarks

This stored procedure returns the following error message:

The trusted option in remote login mapping is no longer supported.

See Also

Linked Servers (Database Engine)