Menu
Home / CSE MCQs / SQL Server MCQs :: Discussion

Discussion :: SQL Server MCQs

  1. 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
    2. A.
    sp_addlinkedsrv
    B.
    sp_addlinkedserver
    C.
    sp_addlinkedsrvlogin
    D.
    None of the mentioned

    View Answer

    Workspace

    View Answer

    Answer : Option C

    Explanation :

    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.

Write your comments here:

Be The First To Comment