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
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
March 30, 2021 at 12:13 PM
search engine optimization services in usa
local seo services in usa
national seo services in usa
small business seo services in usa
ecommerce seo services in usa