【单选题】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 login...
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.
【单选题】You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 co...
A.
Use the ALTER DATABASE statement to change the collation of the databases on SQL1.
B.
Add SQL2 as remote server.
C.
Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
D.
Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.