sp_addlinkedsrvlogin
SQL Server provides the sp_addlinkedsrvlogin system stored procedure to map local logins to logins on the linked servers. This stored procedure can be executed by members of the sysadmin and securityadmin fixed server roles. Its syntax is as follows:
The elements in this syntax are as follows:
• rmtsrvname—The linked server that will use this login setting (@rmtsrvname parameter).
• useself—The setting that determines whether a user or group of users will use their own usernames and passwords to log in to the linked server (@useself parameter). There are two possible settings:
• ‘true’—Local server logins use their own usernames ...
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.
