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

Review Questions

  1. What stored procedure is used to add login mappings for linked servers?
    1. sp_addlogin
    2. sp_addlinkedlogin
    3. sp_addlinkedsrvlogin
    4. sp_addloginmapping
  2. You are managing your company's Clinical SQL Server 2005 server at its headquarters in New Jersey. Your company has three other locations configured as linked servers with the headquarters server: Auburn, Washington; Fort Worth, Texas; and Orlando, Florida. Each is connected to the Clinical server over a virtual private network. Several users have noticed that queries run against the Auburn linked server sometimes time out. Which of the following strategies is likely to resolve the timeout issue for the users?

    1. Decrease the Auburn linked server connection timeout value property.

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