How to allow users on SQL Server to use the OPENROWSET() function to search remote information sources.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

01. sp_configure 'show advanced options', 1

02. RECONFIGURE

03.sp_configure 'Ad Hoc Distributed Queries', 1

04. RECONFIGURE

05. GO

06.

07. SELECT a.*

08. FROM OPENROWSET('SQLNCLI', 'Server=Madrid;Trusted_Connection=yes;',

09. 'SELECT GroupName, Name, DepartmentID

10. FROM AdventureWorks.HumanResources.Department

11. ORDER BY GroupName, Name') AS a;

12. GO

By default, SQL Server does not allow ad hoc distributed queries using OPENROWSET and

OPENDATASOURCE. When this option is set to 1, SQL Server allows ad hoc access. When this

option is not set or is set to 0, SQL Server does not allow ad hoc access.

Ad hoc distributed queries use the OPENROWSET and OPENDATASOURCE functions to

connect to remote data sources that use OLE DB. OPENROWSET and OPENDATASOURCE

should be used only to reference OLE DB data sources that are accessed infrequently. For any

data sources that will be accessed more than several times, define a linked server.

You can access www.free-online-exams.com for the whole latest version of the exam

Get Oracle Certifications for all Exams
Free Online Exams.com