September 2010
Intermediate to advanced
1704 pages
111h 8m
English
sp_addlinkedsrvloginSQL 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 ...