Mapping remote logins to particular local names

The following example maps the login “pogo” from a remote system to the local login “bob”. The user logs in to the remote system as “pogo”. When “pogo” executes remote procedure calls from GATEWAY, the local system maps the remote login name to “bob”.

sp_addlogin bob 
sp_addremotelogin GATEWAY, bob, pogo