Hi friends, today in SQL Server system stored procedure series we will continue with another database mail stored procedure sysmail_help_configure_sp.
Sysmail_help_configure_sp stored procedure is used to display current Database mail configuration settings. The stored procedure sysmail_help_configure_sp is stored in msdb database and owned by schema dbo. Three part name is required if it is used in database other than msdb.
Syntax:
sysmail_help_configure_sp [ [ @parameter_name = ] 'parameter_name' ]
Arguments:
@parameter_name is the name of configuration setting whose information we want to display.
When no parameter_name is defined then it displays the entire database mail configuration setting.
As we configure database mail configuration in our previous blog here.
We changed the configuration setting for Prohibited Extension in previous blog and added bat file extension in parameter value, so we can check the new changed value using this procedure as –
EXEC msdb.dbo.sysmail_help_configure_sp 'ProhibitedExtensions'
To display all the configuration setting we will executed this stored procedure without passing any parameter.
EXEC msdb.dbo.sysmail_help_configure_sp
So in this blog we learn how to display current database mail configuration setting values.
I will continue with another database mail stored procedure in my next blog.
Happy Learning 🙂
Regards,
Kapil Singh
Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook