Error on 'Ad Hoc Distributed Queries'

Posted on: 07 Sep 2011

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.