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.

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial