Export (0) Print
Expand All
2 out of 2 rated this helpful - Rate this topic

Database Mail Configuration Stored Procedures

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?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.