Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sys.remote_logins (Transact-SQL)
Collapse the table of content
Expand the table of content

sys.remote_logins (Transact-SQL)

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.

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Community Additions

ADD
Show:
© 2015 Microsoft