Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.