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:
Get Microsoft® SQL Server 2012 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.
