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
Related content
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru