You work as the network SQL developer at MiracleInfocom .com. All servers on the MiracleInfocom .com network run Microsoft Windows Server 2003 and the database server runs Microsoft SQL Server 2005. You are currently busy configuring the MiracleInfocom.com database server named MiracleInfocom -DB01. You will be required to perform distributed queries against a database that is stored on a SQL server named MiracleInfocom -SR02 which hosts four databases each using a different collation. You have received instruction from the CIO to add MiracleInfocom -SR02 as a linked server on MiracleInfocom -SR01 and you need to make sure the distributed queries are evaluated correctly using the least amount of administrative effort. What should you do?
A. You should set the Use Remote Collation option to True
B. You should set the Use Remote Collation option to False
C. You should use OPENROWSET to retrieve data from MiracleInfocom -SR02
D. You should specify a collation name
Answer:A
You work as the network SQL developer at MiracleInfocom .com. All servers on the MiracleInfocom .com network run Microsoft Windows Server 2003 and the database server runs Microsoft SQL Server 2005. You are currently busy configuring the MiracleInfocom.com database server named MiracleInfocom -DB01. You will be required to perform distributed queries against a database that is stored on a SQL server named MiracleInfocom -SR02 which hosts four databases each using a different collation. You have received instruction from the CIO to add MiracleInfocom -SR02 as a linked server on MiracleInfocom -SR01 and you need to make sure the distributed queries are evaluated correctly using the least amount of administrative effort. What should you do?
A. You should set the Use Remote Collation option to True B. You should set the Use Remote Collation option to False C. You should use OPENROWSET to retrieve data from MiracleInfocom -SR02 D. You should specify a collation name