Here we are going to see how to configure the database mailing, just execute the below code to configure.
Check Using below one:
select * from sys.configurations where name ='Database Mail XPs'
sp_configure N'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure N'Database Mail XPs', 1;
GO
RECONFIGURE;
GO
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'
