sp_helplinkedsrvlogin
To determine the current linked server login settings, you run the sp_helplinkedsrvlogin
procedure, which has the following syntax:
sp_helplinkedsrvlogin [[@rmtsrvname =] 'rmtsrvname',] [[@locallogin =] 'locallogin']
The elements of this syntax are as follows:
• rmtsrvname
—The linked server that will have its login settings displayed.
• locallogin
—The local login mappings that will be displayed.
The following example shows the sp_helplinkedsrvlogin
output if no arguments are provided:
This example displays one line for each linked server login mapping. The first column (Linked Server
) shows which linked server owns this ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.