1 Version 4.0 -- 1/15/89 sp_remoteoption
______________________________________________________________________
NAME: sp_remoteoption
FUNCTION:
Displays or changes remote login options.
SYNTAX:
sp_remoteoption [remoteserver, loginame, remotename,
optname, {true | false}]
EXAMPLES:
1) sp_remoteoption
sp_remoteoption Version 4.0 -- 1/15/89 2
______________________________________________________________________
Displays a list of the remote login options:
Settable remote login options.
remotelogin_option
------------------------
trusted
2)sp_remoteoption GATEWAY, churchy, pogo, trusted, true
Defines the remote login from the remote server GATEWAY to be
trusted. That is, the password won't be checked.
2)sp_remoteoption GATEWAY, churchy, pogo, trusted, false
Defines the remote login from the remote server GATEWAY to be
3 Version 4.0 -- 1/15/89 sp_remoteoption
______________________________________________________________________
untrusted. That is, the password will be checked.
PARAMETERS:
remoteserver - is the name of the remote server that has the
remote login to which the option should apply.
loginame - is the loginame that identifies the remote login for
the remoteserver, loginame, and remotename combination.
remotename - is the remote user name that identifies the remote
login for the remoteserver, loginame, and remotename combina-
tion.
optname - is the name of the option you want to set or unset.
Currently there is only one option. The option trusted means
that the local server will accept remote logins from other
servers without user-access verification for the particular
remote login. The default is to use password verification.
SQL Server understands any unique string that is part of the
sp_remoteoption Version 4.0 -- 1/15/89 4
______________________________________________________________________
option name. Use quotes around the option name if it
includes embedded blanks.
{true | false} - true if you want to set the option, false if
you want to unset the option.
COMMENTS:
o To display a list of the user-settable server options, execute
sp_serveroption with no parameters.
o Only the System Administrator can set or unset particular
server options.
o See System Administration Guide for additional details on
remote login options.
MESSAGES:
Executing sp_remoteoption with no parameters displays a list of
the user-settable options.
5 Version 4.0 -- 1/15/89 sp_remoteoption
______________________________________________________________________
Run sp_remoteoption with no parameters to see options. This mes-
sage is generated in two cases: either the option doesn't
exist, or the user does not have permission to set or unset
it.
The name supplied as the optname parameter is not unique. No
remote login option value was changed. The complete names
that match the string supplied are printed out so you can see
how to make the optname more specific.
Although all users can look at a list of the remote login
options, only the System Administrator can set or unset them.
You aren't the System Administrator.
You have tried to set an option on the local server.
loginame on remote server remoteserver.
You have incorrectly identified the remote login. Run
sp_helpremotelogin to list the remote logins.
Either the optname parameter was omitted or the optvalue parame-
ter was something other than true or false.
sp_remoteoption Version 4.0 -- 1/15/89 6
______________________________________________________________________
PERMISSIONS:
Execute permission for no parameters (display options only) to
public. Execute permission for parameters (change an option) to
System Administrator.
TABLES USED:
master.dbo.spt_values, master.dbo.sysremotelogins,
master.dbo.sysservers
SEE ALSO:
sp_helpremotelogin