O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Answers to Review Questions

  1. C. You can use the sp_addlinkedsrvlogin stored procedure to create or update a mapping between a login on the local instance of SQL Server and a security account on a remote server. You can use sp_addlogin to create a new SQL Server login that allows a user to connect to an instance of SQL Server by using SQL Server authentication. There are no system stored procedures named sp_addlinkedlogin or sp_addloginmapping.
  2. B.Increasing the connection timeout will give the distributed query more time to be resolved. Since only queries to the Auburn server are having timeout problems, the Auburn server is the only one that needs to have the configuration change.
  3. B,E. Windows authentication must be used on both the local server ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required