单选题
Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your company 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?（）
发布日期：2021-03-17
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.
标签： "暂无标签"
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
热门试题热门资讯 相关试题