How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure
1. You can either use SQL Server Surface Area Configuration Tool
2. you can use sp_configure stored procedure to enable the ad hoc connections to remote data sources
- Run this Query
sp_configure 'show advanced options', 1
reconfigure
sp_configure 'Ad Hoc Distributed Queries', 1
No comments:
Post a Comment