sys.sp_remoteoption

general

#stored-procedure

Description

Displays or changes options for a remote login defined on the local server running SQL Server. This stored procedure returns the following error message: Linked servers (Database Engine) This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this doesn’t change any options and returns an error message. It’s supported for backward compatibility only.

Syntax

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

Remarks

Displays or changes options for a remote login defined on the local server running SQL Server.

This stored procedure returns the following error message:

Linked servers (Database Engine)

This feature will be removed in a future version of SQL Server. Avoid using this feature in

new development work, and plan to modify applications that currently use this

doesn’t change any options and returns an error message. It’s

supported for backward compatibility only.