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.