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.
正确答案:C
答案解析:有
微信扫一扫手机做题