black

MCTS(70-431)

单项选择题

Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error.
What should you do？（）

A.Join the two servers by using the four-part syntax of server.database.schema.table.
B.Reference SQL2 by using an alias.
C.Add SQL2 as a remote server to SQL1.
D.Add SQL2 as a linked server to SQL1.

相关考题

单项选择题 You need to write a code segment that transfers the first 80 bytes from a stream variable named stream1 into a new byte array named byteArray. You also need to ensure that the code segment assigns the number of bytes that are transferred to an integer variable named bytesTransferred. Which code segment should you use？（）

单项选择题 You add an Online Responder to an Online Responder Array. You need to ensure that the new  Online Responder resolves synchronization conflicts for all members of the Array.     What should you do（）

单项选择题 Your company has a single Active Directory domain. The domain has servers that run Windows Server 2008 R2. You have a server named NAT1 that functions as a NAT server. You need to ensure that administrators can access a server named RDP1 by using Remote Desktop Protocol (RDP). What should you do？（）

All Rights Reserved 版权所有©建筑考试题库(jzkao.com)

备案号：湘ICP备2020024380号-3