sysmail_help_profile_sp (Transact-SQL)

Applies to: SQL Server

Lists information about one or more mail profiles.

Transact-SQL syntax conventions

Syntax

sysmail_help_profile_sp [ [ @profile_id = ] profile_id | [ @profile_name = ] 'profile_name' ]
[ ; ]

Arguments

[ @profile_id = ] profile_id

The profile ID to return information for. @profile_id is int, with a default of NULL.

[ @profile_name = ] 'profile_name'

The profile name to return information for. @profile_name is sysname, with a default of NULL.

Return code values

0 (success) or 1 (failure).

Result set

Returns a result set with the following columns.

Column name Data type Description
profile_id int The profile ID for the profile.
name sysname The profile name for the profile.
description nvarchar(256) The description for the profile.

Remarks

When a profile name or profile ID is specified, sysmail_help_profile_sp returns information about that profile. Otherwise, sysmail_help_profile_sp returns information about every profile in the SQL Server instance.

The stored procedure sysmail_help_profile_sp is in the msdb database and is owned by the dbo schema. The procedure must be executed 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

A. List all profiles

The following example shows listing all profiles in the instance.

EXEC msdb.dbo.sysmail_help_profile_sp;

Here is a sample result set, reformatted for line length:

profile_id  name                          description
----------- ----------------------------- ------------------------------
56          AdventureWorks Administrator  Administrative mail profile.
57          AdventureWorks Operator       Operator mail profile.

B. List a specific profile

The following example shows listing information for the profile AdventureWorks Administrator.

EXEC msdb.dbo.sysmail_help_profile_sp
    @profile_name = 'AdventureWorks Administrator' ;

Here is a sample result set, reformatted for line length:

profile_id  name                          description
----------- ----------------------------- ------------------------------
56          AdventureWorks Administrator  Administrative mail profile.