You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
You have received instructions from management to allow the users at
Domain.com on the SQL Server sample to use the OPENROWSET() function to search remote information sources.
What should you do?
A.
You should consider configuring the Transaction Logs for sp_configure configuration.
B.
You should consider configuring the Ad Hoc Distributed Queries for sp_configure configuration.
C.
You should consider configuring the router control for sp_configure configuration.
D.
You should consider configuring the Ad Lib Distributed Queries for sp_configure configuration.