In this article I will explain with an example, how to resolve the following error: The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option in SQL Server.
 
 

Configuring advanced options in SQL Server

While executing the sp_configure Stored Procedure with parameter value Database Mail XPs, you will get the following error.
EXEC sp_configure 'Database Mail XPs'
 
The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option
 
In order to get rid of the above error, you need to execute the following query.
SP_CONFIGURE 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
 
Once executed, the following messages will appear which confirms, everything went OK.
The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option
 
Finally, execute the Stored Procedure and you will not get any error as the Stored Procedure is working properly.
EXEC sp_configure 'Database Mail XPs'
 
The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option