When attempting to change an email account in my Database Mail, I received the following error:
Msg 14604, Level 16, State 1, Procedure sysmail_verify_account_sp, Line 14
Both account parameters (id and name) cannot be NULL
The account_id and account_name parameters are required in the sysmail_update_account_sp stored procedure. To find these, I ran the sysmail_help_account_sp stored procedure.
EXEC msdb.dbo.sysmail_help_account_sp;
Then I added the missing parameters to the sysmail_update_account_sp stored procedure.
EXECUTE msdb.dbo.sysmail_update_account_sp @account_id = < account_id > , @account_name = ' < name > ', @email_address = ' < updated email address > ';
Then I reran the sysmail_help_account_sp stored procedure to verify that the e-mail address was updated.
Click here for more information on the Microsoft SQL Server stored procedure: sysmail_update_account_sp