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
Wednesday, 21 April 2010
How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure
Posted on 02:29 by Unknown
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment