1 out of 2 rated this helpful - Rate this topic

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

SQL Server 2005

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

Other Resources

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

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD