Monitor: How to check all database mail profiles in SQL Server using T-SQL

Use following query to find all database mail profiles that are configured,

USE msdb
GO

EXEC sysmail_help_profileaccount_sp;
GO

Output: