Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_remoteoption (Transact-SQL)

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

ms188911.note(en-US,SQL.90).gifNote:
sp_remoteoption does not change any options and returns an error message. It is supported for backward compatibility only.

Topic link icon Transact-SQL Syntax Conventions


sp_remoteoption [ [ @remoteserver= ] 'remoteserver' ] 
     [ , [ @loginame = ] 'loginame' ] 
     [ , [ @remotename = ] 'remotename' ] 
     [ , [ @optname = ] 'optname' ] 
     [ , [ @optvalue = ] 'optvalue' ]

This stored procedure returns the following error message: "The trusted option in remote login mapping is no longer supported."

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.