.png)
sysmail_help_configure_sp (Transact-SQL)
Displays configuration settings for Database Mail.
When no @parameter_name is specified, 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. |
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 is not msdb.
The following example shows listing the Database Mail configuration settings for the SQL Server instance.
EXECUTE 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
