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.

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

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s