Deletes a Database Mail SMTP account. You can also use the Database Mail Configuration Wizard to delete an account.
- [ @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.
This procedure deletes the account specified, regardless of whether the account is in use by a profile. A profile that contains no accounts cannot 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 is not msdb.
The following example shows deleting the Database Mail account named
EXECUTE msdb.dbo.sysmail_delete_account_sp @account_name = 'AdventureWorks Administrator' ;
Other ResourcesDatabase Mail
Database Mail Accounts
Database Mail Profiles
Select Configuration Task (Database Mail)