PrepAway - Latest Free Exam Questions & Answers

Which sp_configure configuration option should you configure?

You administer a SQL Server 2008 instance.
You need to allow users on the SQL Server instance to query remote data sources by using
the OPENROWSET() function.
Which sp_configure configuration option should you configure?

PrepAway - Latest Free Exam Questions & Answers

A.
Remote access

B.
Remote proc trans

C.
Ad Hoc Distributed Queries

D.
Agent XPs

Explanation:


Leave a Reply