sysmail_help_configure_sp (Transact-SQL)

Applies to: SQL Server

Displays configuration settings for Database Mail.

Transact-SQL syntax conventions

Syntax

sysmail_help_configure_sp [ [ @parameter_name = ] 'parameter_name' ]
[ ; ]

Arguments

[ @parameter_name = ] 'parameter_name'

The name of the configuration setting to retrieve. When specified, the value of the configuration setting is returned in the @parameter_value OUTPUT parameter. When no @parameter_name is specified, this stored procedure returns a result set containing all of the Database Mail configuration settings in the instance.

Return code values

0 (success) or 1 (failure).

Result set

When no @parameter_name is specified, sysmail_help_configure_sp returns a result set with the following columns.

Column name Data type Description
paramname nvarchar(256) The name of the configuration parameter.
paramvalue nvarchar(256) The value of the configuration parameter.
description nvarchar(256) A description of the configuration parameter.

Remarks

The stored procedure sysmail_help_configure_sp lists the current Database Mail configuration settings for the instance.

When a @parameter_name is specified, but no output parameter is provided for @parameter_value, this stored procedure produces no output.

The stored procedure sysmail_help_configure_sp is in the msdb database and is owned by the dbo schema. The procedure must be invoked with a three-part name if the current database isn't msdb.

Permissions

This stored procedure is owned by the db_owner role. You can grant EXECUTE permissions for any user, but these permissions may be overridden during a SQL Server upgrade.

Examples

The following example shows listing the Database Mail configuration settings for the SQL Server instance.

EXEC msdb.dbo.sysmail_help_configure_sp;

Here is a sample result set, edited for line length:

paramname                       paramvalue      description
------------------------------- --------------- -----------------------------------------------------------------------------
AccountRetryAttempts            1               Number of retry attempts for a mail server
AccountRetryDelay               5000            Delay between each retry attempt to mail server
DatabaseMailExeMinimumLifeTime  600             Minimum process lifetime in seconds
DefaultAttachmentEncoding       MIME            Default attachment encoding
LoggingLevel                    2               Database Mail logging level: normal - 1, extended - 2 (default), verbose - 3
MaxFileSize                     1000000         Default maximum file size
ProhibitedExtensions            exe,dll,vbs,js  Extensions not allowed in outgoing mails