YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.AuserinyourcompanynamedEricwritesmanyadhocqueriesagainstthecompanydatabases.ErichasaccesstotheCustomerdatabaseonSQLHedoesnothaveaccesstotheSalesdatabaseonSQL2.YouneedtoensurethatEriccanwritequeriesthatjoininformationfrombothservers.Whatshouldyoudofirst?（）
A.CreatealinkedserveronSQL1toSQL2.Configurethelinkedservertouseimpersonation.
B.CreatealinkedserveronSQL1toSQL2.Configurethelinkedservertousemappedlogins.
C.InstructErictowritethequeriesonSQL2byusingtheOPENQUERYstatementandspecifyingSQL1astheservername.
D.InstructErictospecifySQLServerobjectnamesbyusingfour-partnotation.
参考答案：B
