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.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru