Home | User-Defined Functions | Tips & Tricks | SQL Server 2005 | Forums | Frequently Asked Questions | Practice Test |    
SQL Server Helper Forum
SQL Server Helper Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000/2005
 Data Transformation Services (DTS)
 Enable the Ad Hoc Distributed Queries
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Utkarsh

India
16 Posts

Posted - 11/20/2007 :  00:02:40  Show Profile  Reply with Quote
Hi
I am using SQL Server 2005.
i want to enable the Ad Hoc Distributed Queries.

I have a procedure...

-------------------------------------
EXEC sp_configure 'show advanced options'
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
-------------------------------------

But it is giving error...


Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'Ad Hoc Distributed Queries' does not exist, or it may be an advanced option.


So how can i find advanced option, and how can i solve this error, and how can i enable the Ad Hoc Distributed Queries.

please help me to solve this problem.

Thanks in advance.


Utkarsh Gajjar

sqlAdmin

72 Posts

Posted - 11/20/2007 :  07:52:17  Show Profile  Reply with Quote
You should pass a value of 1 to the sp_configure function to show the advanced options:

EXEC sp_configure 'show advanced options', '1'
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
   
SQL Server Helper Forum © 2006 SQL Server Helper Go To Top Of Page
Powered By: Snitz Forums 2000 Version 3.4.06