sp_helpremotelogin prints information about the remote logins on a server. The following 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