When i execute the following query in sql server
EXEC sp_configure 'show advanced options', '1'
RECONFIGURE
EXEC sp_configure 'Ad Hoc Distributed Queries', '1'
RECONFIGURE;
i got the following error.
-----------------------------------------------------------------------------------
Msg 15247, Level 16, State 1, Procedure sp_configure, Line 94
User does not have permission to perform this action.
Msg 5812, Level 14, State 1, Procedure AdHoc, Line 12
You do not have permission to run the RECONFIGURE statement.
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.
Msg 5812, Level 14, State 1, Procedure AdHoc, Line 16
You do not have permission to run the RECONFIGURE statement.
------------------------------------------------------------------------------------
Pl's help me?