题目内容

TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. A user in TestKing.com named Eric writes many ad hoc queries against the company databases.Eric has access to the Customer database on SQL1. He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that join information from both servers. What should you do first？（）

A. Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.
B. Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.
C. Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name.
D. Instruct Eric to specify SQL Server object names by using four-part notation.

查看答案

搜索结果不匹配？点我反馈

更多问题

ZD6系列电动转辙机主轴组由主轴套止挡栓和（）组成。

A. 滚动轴承
B. 主轴
C. 挡圈
D. 锁闭齿轮

什么叫填隙碎石？

单只标的证券的融券余量达到该证券上市可流通量的15%时，交易所可以在次一交易日暂停其融券卖出，并向市场公布。（）

A. 正确
B. 错误

什么是沥青路面的透层？