Skip to content

Latest commit

 

History

History
107 lines (74 loc) · 3.27 KB

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

File metadata and controls

107 lines (74 loc) · 3.27 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sysmail_help_profile_sp (Transact-SQL)
Lists information about one or more mail profiles.
markingmyname
maghan
randolphwest
05/30/2023
sql
system-objects
reference
sysmail_help_profile_sp_TSQL
sysmail_help_profile_sp
sysmail_help_profile_sp
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.

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.

Related content