YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.AuserinyourcompanynamedE
2021-05-05
YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.AuserinyourcompanynamedEricwritesmanyadhocqueriesagainstthecompanydatabases.ErichasaccesstotheCustomerdatabaseonSQL1.HedoesnothaveaccesstotheSalesdatabaseonSQL2.YouneedtoensurethatEriccanwritequeriesthatjoininformationfrombothservers.Whatshouldyoudofirst?（）
A.CreatealinkedserveronSQL1toSQL2.Configurethelinkedservertouseimpersonation.
B.CreatealinkedserveronSQL1toSQL2.Configurethelinkedservertousemappedlogins.
C.InstructErictowritethequeriesonSQL2byusingtheOPENQUERYstatementandspecifyingSQL1astheservername.
D.InstructErictospecifySQLServerobjectnamesbyusingfour-partnotation.
正确答案：参考B
词条内容仅供参考，如果您需要解决具体问题
（尤其在法律、医学等领域），建议您咨询相关领域专业人士。