Edit

sysmail_delete_account_sp (Transact-SQL)

  • Article

Applies to: SQL Server Azure SQL Managed Instance

Deletes a Database Mail SMTP account. You can also use the Database Mail Configuration Wizard to delete an account.

Transact-SQL syntax conventions

Syntax

sysmail_delete_account_sp { [ @account_id = ] account_id | [ @account_name = ] 'account_name' }
[ ; ]

Arguments

[ @account_id = ] account_id

The ID number of the account to delete. @account_id is int, with no default. Either @account_id or @account_name must be specified.

[ @account_name = ] 'account_name'

The name of the account to delete. @account_name is sysname, with no default. Either @account_id or @account_name must be specified.

Return code values

0 (success) or 1 (failure).

Result set

None.

Remarks

This procedure deletes the account specified, regardless of whether the account is in use by a profile. A profile that contains no accounts can't successfully send e-mail.

The stored procedure sysmail_delete_account_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

The following example shows deleting the Database Mail account named AdventureWorks Administrator.

EXEC msdb.dbo.sysmail_delete_account_sp
    @account_name = 'AdventureWorks Administrator';

Related content