sp-remoteoption-transact-sql.md

title	sp_remoteoption (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sp_remoteoption_TSQL sp_remoteoption
dev_langs	TSQL
helpviewer_keywords	sp_remoteoption
ms.assetid	c9a7309b-eab7-4192-a414-e282581af4e5
caps.latest.revision	21
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sp_remoteoption (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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

Note

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

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

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)