题目内容
（请给出正确答案）
[主观题]
You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. a
d hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.
You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.
How should you configure SQL1？
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.
如搜索结果不匹配，请 联系老师 获取答案
