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