{"id":9840,"date":"2020-09-12T08:29:20","date_gmt":"2020-09-11T22:29:20","guid":{"rendered":"https:\/\/database.guide\/?p=9840"},"modified":"2020-09-12T08:29:23","modified_gmt":"2020-09-11T22:29:23","slug":"update-a-database-mail-account-in-sql-server-t-sql","status":"publish","type":"post","link":"https:\/\/database.guide\/update-a-database-mail-account-in-sql-server-t-sql\/","title":{"rendered":"Update a Database Mail Account in SQL Server (T-SQL)"},"content":{"rendered":"\n

In SQL Server<\/a>, you can use the sysmail_update_account_sp<\/code> stored procedure in the msdb<\/code> database to update your existing Database Mail accounts with T-SQL<\/a>. <\/p>\n\n\n\n\n\n\n\n

Update the Account Details<\/h2>\n\n\n\n

You can update an account’s details based on its name.<\/p>\n\n\n\n

That is, if you don’t need to change the account name, you don’t need to provide the account ID – as long as you provide the name.<\/p>\n\n\n\n

Example:<\/p>\n\n\n\n

EXECUTE msdb.dbo.sysmail_update_account_sp  \n    @account_name = 'DB Admin',  \n    @description = 'Mail account for admin emails.',  \n    @email_address = 'admin@example.com',  \n    @replyto_address = 'reply@example.com',  \n    @display_name = 'DB Automated Mailer',  \n    @mailserver_name = 'smtp.example.com',\n    @port = 25;<\/code><\/pre>\n\n\n\n
Update the Account Name<\/h2>\n\n\n\n
When both the account name and the account ID are specified, the stored procedure changes the account name in addition to updating the information for the account. <\/p>\n\n\n\n
EXECUTE msdb.dbo.sysmail_update_account_sp\n    @account_id = 1,\n    @account_name = 'Updated DB Admin',  \n    @description = 'Mail account for admin emails.',  \n    @email_address = 'admin@example.com',  \n    @replyto_address = 'reply@example.com',  \n    @display_name = 'DB Automated Mailer',  \n    @mailserver_name = 'smtp.example.com',\n    @port = 25;<\/code><\/pre>\n\n\n\n
In this example I updated the name and various other details of the account. <\/p>\n\n\n\n
The Syntax<\/h2>\n\n\n\n
The official syntax goes like this:<\/p>\n\n\n\n
sysmail_update_account_sp [ [ @account_id = ] account_id ] [ , ] [ [ @account_name = ] 'account_name' ] ,  \n    [ @email_address = ] 'email_address' ,   \n    [ @display_name = ] 'display_name' ,   \n    [ @replyto_address = ] 'replyto_address' ,  \n    [ @description = ] 'description' ,   \n    [ @mailserver_name = ] 'server_name' ,   \n    [ @mailserver_type = ] 'server_type' ,   \n    [ @port = ] port_number ,   \n    [ @timeout = ] 'timeout' ,  \n    [ @username = ] 'username' ,  \n    [ @password = ] 'password' ,  \n    [ @use_default_credentials = ] use_default_credentials ,  \n    [ @enable_ssl = ] enable_ssl<\/code><\/pre>\n\n\n\n
See the Microsoft documentation<\/a> for a detailed explanation of each argument. <\/p>\n\n\n\n
Note that the sysmail_update_account_sp<\/code> stored procedure is in the msdb<\/code> database, and it’s owned by the dbo<\/code> schema. Therefore, you’ll need to use three part naming if you execute it from outside the msdb<\/code> database.<\/p>\n\n\n\n
You can also use the sysmail_add_account_sp<\/code> stored procedure to create a new Database Mail account<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"
In SQL Server, you can use the sysmail_update_account_sp stored procedure in the msdb database to update your existing Database Mail accounts with T-SQL.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[10,77,104,61],"class_list":["post-9840","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-how-to","tag-mssql","tag-send-email","tag-t-sql"],"_links":{"self":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/9840","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/comments?post=9840"}],"version-history":[{"count":4,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/9840\/revisions"}],"predecessor-version":[{"id":9941,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/9840\/revisions\/9941"}],"wp:attachment":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/media?parent=9840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/categories?post=9840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/tags?post=9840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}