In this article I will explain with an example, how to enable 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.
 
 

Enabling Database Mail in SQL Server

The database emails can be enabled using msdb.dbo.sysmail_start_sp Stored Procedure.
-- Enabling Database Mail
EXECUTE msdb.dbo.sysmail_start_sp
 
Enable Database Mail in SQL Server
 
 

Disabling Database Mail in SQL Server

For disabling database mail services, please refer my article Disable Database Mail in SQL Server.