How to enable OPENROWSET and OPENDATASOURCE support in SQL Server 2008

Lajapathy Arun
12y
9.9k
0
0

Blog

How to enable OPENROWSET and OPENDATASOURCE support in SQL Server 2008

exec sp_configure 'show advanced options', 1

RECONFIGURE;

exec sp_configure 'Ad Hoc Distributed Queries', 1

RECONFIGURE;

Output:

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Configuration option 'Ad Hoc Distributed Queries' changed from 1 to 1. Run the RECONFIGURE statement to install.

How to enable OPENROWSET and OPENDATASOURCE support in SQL Server 2008

Up Next

SQL Language

Convert Multiple Rows into One Comma Separated Values in SQL server 2008

Ebook Download

View all

C# Corner Ebook

SQL Queries For Beginners

Read by 5.2k people

Download Now!

Learn

View all

Learn Image