In this article I will explain with an example, how to disable database mail in SQL Server.
This article is applicable to following SQL Server versions i.e. 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 and 2022.
 
 

Disabling Database Mail in SQL Server

The database emails can be disabled using msdb.dbo.sysmail_stop_sp Stored Procedure.
-- Disabling Database Mail
EXECUTE msdb.dbo.sysmail_stop_sp
 
Disable Database Mail in SQL Server
 
 

Enabling Database Mail in SQL Server

For enabling database mail services, please refer my article Enable Database Mail in SQL Server.