Configuring Ad Hoc Distributed Queries in SQL SEREVER

exec sp_configure 'show advanced options', 1
RECONFIGURE;
exec sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE;

Output:

Configuration option 'show advanced options' changed from 1 to 1. 
Run the RECONFIGURE statement to install.

Configuration option 'Ad Hoc Distributed Queries' changed from 1 to 1. 
Run the RECONFIGURE statement to install.

Configuring Database Mailing in SQL SERVER

Here we are going to see how to configure the database mailing, just execute the below code to configure.

sp_configure N'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure N'Database Mail XPs', 1;
GO
RECONFIGURE;
GO

Check Using below one:

select * from sys.configurations where name ='Database Mail XPs'