jayakrishnan Morayur

jayakrishnan Morayur

  • NA
  • 193
  • 258.7k

Error on 'Ad Hoc Distributed Queries'

Sep 7 2011 1:54 AM
        
        i have a query bellow GO
/****** Object:  StoredProcedure [dbo].[AdHoc]    Script Date: 09/07/2011 11:22:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



ALTER PROCEDURE [dbo].[AdHoc]

AS
BEGIN

EXEC sp_configure 'show advanced options', '1'

RECONFIGURE

EXEC sp_configure 'Ad Hoc Distributed Queries', '1'

RECONFIGURE;

END


But the following error occur


User does not have permission to perform this action.
You do not have permission to run the RECONFIGURE statement.
The configuration option 'Ad Hoc Distributed Queries' does not exist, or it may be an advanced option.
You do not have permission to run the RECONFIGURE statement.

Answers (1)