sp_remoteoption (Transact-SQL)
Displays or changes options for a remote login defined on the local server running SQL Server.
Note
sp_remoteoption does not change any options and returns an error message. It is supported for backward compatibility only.
.gif "Topic link icon")
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."