TechNet
Export (0) Print
Expand All

sysmail_update_profile_sp (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Changes the description or name of a Database Mail profile.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions


sysmail_update_profile_sp [ [ @profile_id = ] profile_id , ] [ [ @profile_name = ] 'profile_name' , ]
    [ [ @description = ] 'description' ]

[ @profile_id = ] profile_id
The profile id to update. profile_id is int, with a default of NULL. At least one of profile_id or profile_name must be specified. If both are specified, the procedure changes the name of the profile.

[ @profile_name = ] 'profile_name'
The name of the profile to update or the new name for the profile. profile_name is sysname, with a default of NULL. At least one of profile_id or profile_name must be specified. If both are specified, the procedure changes the name of the profile.

[ @description = ] 'description'
The new description for the profile. description is nvarchar(256), with a default of NULL.

0 (success) or 1 (failure)

When both the profile id and the profile name are specified, the procedure changes the name of the profile to the provided name and updates the description for the profile. When only one of these arguments is provided, the procedure updates the description for the profile.

The stored procedure sysmail_update_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 is not msdb.

Execute permissions for this procedure default to members of the sysadmin fixed server role.

A. Changing the description of a profile

The following example changes the description for the profile named AdventureWorks Administrator in the msdb database.

EXECUTE msdb.dbo.sysmail_update_profile_sp
    @profile_name = 'AdventureWorks Administrator'
    ,@description = 'Administrative mail profile.';

B. Changing the name and description of a profile

The following example changes the name and description of the profile with the profile id 750.

EXECUTE msdb.dbo.sysmail_update_profile_sp
    @profile_id = 750
    ,@profile_name = 'Operator'
    ,@description = 'Profile to send alert e-mail to operators.';

Database Mail
Database Mail Configuration Objects
Create a Database Mail Account
Database Mail Stored Procedures (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft