Sysmail_help_configure_sp – Day 11 – SQL Server System Stored Procedure

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'

sysmail_help_configure

   

To display all the configuration setting we will executed this stored procedure without passing any parameter.

EXEC msdb.dbo.sysmail_help_configure_sp

sysmail_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 

Follow me on Twitter

   

About Kapil Singh Kumawat

Kapil Singh Kumawat has been working with SQL Server since last 5 years. He is from Jaipur, Rajasthan, India and currently working with Cognizant Technology Solutions as SQL Server Developer. He has good experience in performance tuning, SSIS, data migration and data designing. Apart from database he has interest in travelling, watching football and listening music.

View all posts by Kapil Singh Kumawat →

Leave a Reply

Your email address will not be published.