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?

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?

A.
Remote access

B.
Remote proc trans

C.
Ad Hoc Distributed Queries

D.
Agent XPs

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *