{"id":9809,"date":"2020-09-03T09:55:10","date_gmt":"2020-09-02T23:55:10","guid":{"rendered":"https:\/\/database.guide\/?p=9809"},"modified":"2020-09-11T08:40:51","modified_gmt":"2020-09-10T22:40:51","slug":"create-a-database-mail-profile-in-sql-server-t-sql","status":"publish","type":"post","link":"https:\/\/database.guide\/create-a-database-mail-profile-in-sql-server-t-sql\/","title":{"rendered":"Create a Database Mail Profile in SQL Server (T-SQL)"},"content":{"rendered":"\n

When you use Database Mail in SQL Server<\/a> to send emails<\/a>, you can specify a Database Mail profile to send the mail from. <\/p>\n\n\n\n

In some cases you will be required to specify a profile when you send the email. This is the case when the user does not have a default private profile and there is no default public profile for the database.<\/p>\n\n\n\n

You can create Database Mail profiles with T-SQL<\/a> by executing the sysmail_add_profile_sp<\/code> stored procedure in the msdb<\/code> database. <\/p>\n\n\n\n\n\n\n\n

Example<\/h2>\n\n\n\n

Here’s an example of creating a Database Mail profile.<\/p>\n\n\n\n

EXECUTE msdb.dbo.sysmail_add_profile_sp  \n    @profile_name = 'DB Admin Profile',  \n    @description = 'Profile for admin emails.';<\/code><\/pre>\n\n\n\n
In this example I specify a profile name of “DB Admin Profile”, and I provide a description. <\/p>\n\n\n\n
You also have the option of providing a third argument to return the ID of the new profile (see syntax below).<\/p>\n\n\n\n
Note that the sysmail_add_profile_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
The Syntax<\/h2>\n\n\n\n
The official syntax goes like this:<\/p>\n\n\n\n
sysmail_add_profile_sp [ @profile_name = ] 'profile_name'  \n    [ , [ @description = ] 'description' ]  \n    [ , [ @profile_id = ] new_profile_id OUTPUT ]<\/code><\/pre>\n\n\n\n
See the Microsoft documentation<\/a> for a detailed explanation of each argument. <\/p>\n\n\n\n
You can also use the sysmail_update_profile_sp<\/code> stored procedure to update an existing Database Mail profile<\/a>. <\/p>\n\n\n\n
Configuring Database Mail<\/h2>\n\n\n\n
Creating a profile is just one of several things you need to do before you can send email with that profile. <\/p>\n\n\n\n
Once you’ve created the profile, you’ll need to add at least one Database Mail account to that profile<\/a> (which means that you first need to create an account<\/a>, if it doesn’t exist already). You’ll also need to grant a user in the msdb<\/strong> database access to the profile<\/a>.<\/p>\n\n\n\n
See How to Send Email in SQL Server<\/a> for a complete example of configuring Database Mail, then sending an email.<\/p>\n","protected":false},"excerpt":{"rendered":"
When you use Database Mail in SQL Server to send emails, you can specify a Database Mail profile to send the mail from. In some cases you will be required to specify a profile when you send the email. This is the case when the user does not have a default private profile and there … Read more<\/a><\/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-9809","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\/9809","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=9809"}],"version-history":[{"count":7,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/9809\/revisions"}],"predecessor-version":[{"id":9940,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/9809\/revisions\/9940"}],"wp:attachment":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/media?parent=9809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/categories?post=9809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/tags?post=9809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}