Database Mail and SQL Mail Stored Procedures (Transact-SQL)

Microsoft SQL Server 2005 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

SQL Mail Procedures

sp_processmail	xp_sendmail
xp_deletemail	xp_startmail
xp_findnextmsg	xp_stopmail
xp_readmail

See Also

Other Resources

Database Mail
SQL Mail
SQL Server Agent Mail
Database Mail Configuration Wizard

Help and Information

Getting SQL Server 2005 Assistance

Last updated on 2008-12-03