sp_helpremotelogin displays information about the remote logins on a server.
This example shows the remote login “pogo” mapped locally to login name “bob”, with all other remote logins keeping their remote names:
sp_helpremotelogin
server remote_user_name local_user_name options --------- ---------------- ----------------- -------- GATEWAY **mapped locally** **use local name** untrusted GATEWAY pogo bob untrusted