问题:
TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.You need to write a distributed query that joins the data on SQL1 with the data on SQL2.
What should you do?()
A . Ensure that both SQL1 and SQL2 use the same login name as the security context for each server.
B . Configure SQL2 as a remote server. Write the query on SQL1.
C . Configure SQL2 as a linked server to impersonate the remote login.
D . Configure SQL2 as a distributed server. Use pass-through authentication.
TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.You need to write a distributed query that joins the data on SQL1 with the data on SQL2.
What should you do?()
● 参考解析
本题暂无解析