Posted in Development, Stored Procedure

Sysmail_help_configure_sp – SQL Server Database Mail Stored Procedure – Part 2

Hi friends, today 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.


sysmail_help_configure_sp  [ [ @parameter_name = ] ‘parameter_name’ ]


@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 other database mail stored procedure in my next blog. Have a nice day 🙂



I am Kapil Singh Kumawat working on SQL Server since last 5 years. I am from Jaipur, Rajasthan, India and currently working in Cognizant Technology Solutions as SQL Server Developer. I have a good experience in writing queries, performance tuning, SSIS, SSAS, Power BI, Data migration and database designing. Apart from database I have interest in travelling,watching football and listening music. My blogs are also published on

One thought on “Sysmail_help_configure_sp – SQL Server Database Mail Stored Procedure – Part 2

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s