Hi,
I got it to work by running the following:
EXEC
sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC
sp_configure 'Ad Hoc Distributed Queries', 1
GO
I got the message
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Configuration option 'Ad Hoc Distributed Queries' changed from 0 to 1. Run the RECONFIGURE statement to install
Then I typed: RECONFIGURE and got the message:
Command(s) completed successfully.
Is this correct? Do I have to do anything else to change the 'show advanced options back to 0?
Isabelle
Thanks!
Bea Isabelle