Returns a row per remote-login mapping. This catalog view is used to map incoming local logins that claim to be coming from a corresponding server to an actual local login.
|
Column name
|
Data type
|
Description
|
|---|
|
server_id
|
int
|
ID of the server in sys.servers. This name is supplied by the connection from the "remote" server.
|
|
remote_name
|
sysname
|
Login name that the connection will supply to be mapped. If NULL, the login name that is specified in the connection is used.
|
|
local_principal_id
|
int
|
ID of the server principal to whom the login is mapped. If 0, the remote login is mapped to the login with the same name.
|
|
modify_date
|
datetime
|
Date the linked login was last changed.
|
See Also