Skip to content

sysmail-help-profile-sp-transact-sql.md

Latest commit

 

History

History
106 lines (73 loc) · 3.27 KB

sysmail-help-profile-sp-transact-sql.md

File metadata and controls

106 lines (73 loc) · 3.27 KB
title sysmail_help_profile_sp (Transact-SQL)
description Lists information about one or more mail profiles.
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sysmail_help_profile_sp_TSQL
sysmail_help_profile_sp
helpviewer_keywords
sysmail_help_profile_sp
dev_langs
TSQL

sysmail_help_profile_sp (Transact-SQL)

[!INCLUDE SQL Server]

Lists information about one or more mail profiles.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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 [!INCLUDE ssNoVersion] 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

[!INCLUDE msdb-execute-permissions]

Examples

A. List all profiles

The following example shows listing all profiles in the instance.

EXECUTE 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.

EXECUTE 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.

Related content