可学答题网 > 问答 > MCTS(70-431)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Your application must 


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?()

  • AJoin the two servers by using the four-part syntax of server.database.schema.table.
  • BReference SQL2 by using an alias.
  • CAdd SQL2 as a remote server to SQL1.
  • DAdd SQL2 as a linked server to SQL1.
参考答案
参考解析:
分类:MCTS(70-431)题库
相关推荐

1、若a=5,b=3,c=4,逻辑表达式!(a+b)&;&;!c的值

若a=5,b=3,c=4,逻辑表达式!(a+b)&;&;!c的值为()A0B-1C1D2

2、Your web application u

Your web application uses a simple architecture in which servlets handle requests and then forw...

3、表达式10>5&&6%3的值是()

表达式10>5&&6%3的值是()A-1B非零值C0D1

4、Your web application r

Your web application requires the ability to load and remove web files dynamically to the ...

5、Your web application v

Your&ensp;web&ensp;application&ensp;views&ensp;all&ensp;have&ensp;the&ensp;same&ensp;header,&ensp;which&ensp;includes&ensp;the&ensp;<title>&ensp;tag&ensp;in&ensp;th...

6、Your web application u

Your&ensp;web&ensp;application&ensp;uses&ensp;a&ensp;simple&ensp;architecture&ensp;in&ensp;which&ensp;servlets&ensp;handle&ensp;requests&ensp;and&ensp;then&ensp;forw...