Sail E0 Webinar
Question
Which of the following command tells that all local users are logged in as "sa in the following code ?EXEC sp_addlinkedsrvlogin@rmtsrvname = "Northwinds",@useself = "false",@locallogin = "sa",@rmtuser = "Admin",@rmtpassword = NULL
Options:
A .  sp_addlinkedsrv
B .  sp_addlinkedserver
C .  sp_addlinkedsrvlogin
D .  None of the mentioned
Answer: Option C


sp_addlinkedsrvlogin creates or updates a mapping between a login on the local instance of SQL Server and a security account on a remote server.



Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers