itgle.com
YourapplicationmustaccessdatathatislocatedontwoSQLServer2005computers.OneoftheseserversisnamedSQL1andtheotherisSQL2.YouhavepermissionstocreateastoredprocedureonSQL1tosupportyourapplication.However，onSQL2youonlyhavepermissionstoselectdata.Youwritethestored
题目
YourapplicationmustaccessdatathatislocatedontwoSQLServer2005computers.OneoftheseserversisnamedSQL1andtheotherisSQL2.YouhavepermissionstocreateastoredprocedureonSQL1tosupportyourapplication.However，onSQL2youonlyhavepermissionstoselectdata.YouwritethestoredprocedureonSQL1.ThestoredprocedureaccessesSQL2byusingtheOPENQUERYTransact-SQLstatement.However,thequeryfailswhenexecuted.Youneedtotroubleshootthecauseoftheerror.Whatshouldyoudo？（）
A.Jointhetwoserversbyusingthefour-partsyntaxofserver.database.schema.table.
B.ReferenceSQL2byusinganalias.
C.AddSQL2asaremoteservertoSQL1.
D.AddSQL2asalinkedservertoSQL1.