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 2014 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.