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?()
- AEnsure that both SQL1 and SQL2 use the same login name as the security context for each server.
- BConfigure SQL2 as a remote server. Write the query on SQL1.
- CConfigure SQL2 as a linked server to impersonate the remote login.
- DConfigure SQL2 as a distributed server. Use pass-through authentication.