Question 12


Answer D is correct. You can programmatically map linked server logins by using the sp_addlinkedsrvlogin procedure. sp_helplogins provides information about logins and users but does nothing to create or map users. sp_addlogin can be used to add logins to the local instance. sp_adduser adds a login to a database. sp_grantlogin creates a SQL Server login on a local instance.

For more information, see the following sources:

  • Chapter 1, "Installing and Configuring SQL Server 2005"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Accessing and Changing Database Data, Distributed Queries, Accessing External Data"

  • SQL Server 2005 Books Online: "SQL Server Language Reference, Transact-SQL Reference, System Stored Procedures (Transact-SQL), Distributed Queries Stored Procedures (Transact-SQL), sp_addlinkedsrvlogin"

  • "Establishing Security for Linked Servers," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_24tv.asp

  • Within MSDN Library, go to MSDN Home, MSDN Library, Servers and Enterprise Development, SQL Server, SQL Server 2005, Managing Servers, Configuring Linked Servers.




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net