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.

Topic link iconTransact-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

Other Resources

Linking Servers

Help and Information

Getting SQL Server 2005 Assistance