Database Mail Stored Procedures (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Microsoft SQL Server supports the following system stored procedures that are used to perform e-mail operations from within an instance of SQL Server.

Database Mail Procedures

sp_send_dbmail sysmail_help_configure_sp
sysmail_add_account_sp sysmail_help_principalprofile_sp
sysmail_add_principalprofile_sp sysmail_help_profile_sp
sysmail_add_profile_sp sysmail_help_profileaccount_sp
sysmail_add_profileaccount_sp sysmail_help_queue_sp
sysmail_configure_sp sysmail_help_status_sp
sysmail_delete_account_sp sysmail_start_sp
sysmail_delete_log_sp sysmail_stop_sp
sysmail_delete_mailitems_sp sysmail_update_account_sp
sysmail_delete_principalprofile_sp sysmail_update_principalprofile_sp
sysmail_delete_profile_sp sysmail_update_profile_sp
sysmail_delete_profileaccount_sp sysmail_update_profileaccount_sp
sysmail_help_account_sp

See Also

Database Mail