sp_remoteoption (Transact-SQL)
Applies to: SQL Server
Displays or changes options for a remote login defined on the local server running SQL Server.
Note
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 feature.sp_remoteoption does not change any options and returns an error message. It is supported for backward compatibility only.
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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for