Displaying Information About Remote Users

The sp_helpremotelogin stored procedure displays information about a particular remote server's logins or about all remote servers' logins.

    To display information about remote logins

• Type:

  sp_helpremotelogin [remoteserver [, remotename]]

  where

  remoteserver

  Specifies 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

  Specifies a particular remote user on the remote server.

For example, to display information about all remote users of the remote server ACCOUNTS:

sp_helpremotelogin ACCOUNTS

server  remote_user_name     local_user_name      options
------- -------------------- -------------------- ---------
ACCOUNTS ** mapped locally ** ** use local name ** 
ACCOUNTS    chris             salesmgr             trusted

For more information about sp_helpremotelogin, see the Microsoft SQL Server Transact-SQL Reference.