3 out of 3 rated this helpful - Rate this topic

Database Mail Configuration Stored Procedures

SQL Server 2005

Database Mail configuration stored procedures are located in the msdb database.

The following tables list the stored procedures used for configuring and managing Database Mail.

Name	Description
sysmail_configure_sp (Transact-SQL)	Changes configuration settings for Database Mail.
sysmail_help_configure_sp (Transact-SQL)	Displays configuration settings for Database Mail.

Name	Description
sysmail_add_account_sp (Transact-SQL)	Creates a new Database Mail account.
sysmail_add_profile_sp (Transact-SQL)	Creates a new Database Mail profile.
sysmail_add_profileaccount_sp (Transact-SQL)	Adds a mail account to a Database Mail profile.
sysmail_delete_account_sp (Transact-SQL)	Deletes a Database Mail account.
sysmail_delete_profile_sp (Transact-SQL)	Deletes a Database Mail profile.
sysmail_delete_profileaccount_sp (Transact-SQL)	Removes an account from a Database Mail profile.
sysmail_help_account_sp (Transact-SQL)	Lists information about Database Mail accounts.
sysmail_help_profile_sp (Transact-SQL)	Lists information about one or more Database Mail profiles.
sysmail_help_profileaccount_sp (Transact-SQL)	Lists the accounts associated with one or more Database Mail profiles.
sysmail_update_account_sp (Transact-SQL)	Updates the information in an existing Database Mail account.
sysmail_update_profile_sp (Transact-SQL)	Changes the description or name of a Database Mail profile.
sysmail_update_profileaccount_sp (Transact-SQL)	Updates the sequence number of an account within a Database Mail profile.

Name	Description
sysmail_add_principalprofile_sp (Transact-SQL)	Grants permission for a database principal to use a Database Mail profile.
sysmail_delete_principalprofile_sp (Transact-SQL)	Removes permission for a database user to use a public or private Database Mail profile.
sysmail_help_principalprofile_sp (Transact-SQL)	Lists Database Mail profile information for a given database user.
sysmail_update_principalprofile_sp (Transact-SQL)	Updates the permission information for a given database user.

Name	Description
sysmail_start_sp (Transact-SQL)	Starts the Database Mail external program and the associated SQL Service Broker queue.
sysmail_stop_sp (Transact-SQL)	Stops the Database Mail external program and the associated SQL Service Broker queue.
sysmail_help_status_sp (Transact-SQL)	Indicates if Database Mail is started.

Name	Description
sysmail_delete_log_sp (Transact-SQL)	Deletes events from the Database Mail log.
sysmail_delete_mailitems_sp (Transact-SQL)	Deletes e-mails from the Database Mail tables.
sysmail_help_queue_sp (Transact-SQL)	Indicates the status of the Database Mail queues.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions