1 Version 4.0 -- 1/15/89 sp_helpremotelogin
______________________________________________________________________
NAME: sp_helpremotelogin
FUNCTION:
Reports information about a particular remote server's logins or
all remote servers' logins.
SYNTAX:
sp_helpremotelogin [remoteserver [,remotename]]
EXAMPLES:
1) sp_helpremotelogin GATEWAY
sp_helpremotelogin Version 4.0 -- 1/15/89 2
______________________________________________________________________
Displays information about all the remote users of the GATEWAY
server.
2) sp_helpremotelogin
Displays information about all the remote users of all the remote
servers known to the local server.
PARAMETERS:
remoteserver - is the name of the server about which remote
login information is to be displayed. Omitting this optional
parameter results in a report about remote logins for all
remote servers.
remotename - is the name of a particular remote user on the
remote server.
COMMENTS:
3 Version 4.0 -- 1/15/89 sp_helpremotelogin
______________________________________________________________________
o Executing sp_helpremoteserver reports on the remote logins for
the specified server when server is given, or on all servers
when no parameter is supplied.
MESSAGES:
The specified server isn't listed in master.dbo.sysservers. Run
the procedure without the server parameter to see remote
login information for all the servers. To get a list of all
the servers, run sp_helpserver.
The remote server has no entries in the sysremotelogins table.
There are no remote logins for any remote server in sysremotelo-
gins.
The sysservers table has no entries for remote servers.
PERMISSIONS:
Execute permission to public.
sp_helpremotelogin Version 4.0 -- 1/15/89 4
______________________________________________________________________
TABLES USED:
master.dbo.sysservers, master.dbo.sysremotelogins
SEE ALSO:
sp_helpserver, sp_addremotelogin, sp_dropremotelogin