Skip to content

sp-remoteoption-transact-sql.md

Latest commit

 

History

History
50 lines (39 loc) · 1.58 KB

sp-remoteoption-transact-sql.md

File metadata and controls

50 lines (39 loc) · 1.58 KB
title sp_remoteoption (Transact-SQL)
description sp_remoteoption displays or changes options for a remote login defined on the local server running SQL Server.
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sp_remoteoption_TSQL
sp_remoteoption
helpviewer_keywords
sp_remoteoption
dev_langs
TSQL

sp_remoteoption (Transact-SQL)

[!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

Syntax

sp_remoteoption
    [ @remoteserver = ] N'remoteserver'
    [ , [ @loginame = ] N'loginame' ]
    [ , [ @remotename = ] N'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.

Related content