This article explains how to create a Database Mail profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see How to Create a Database Mail Profile in SQL Server (T-SQL).
Continue readingThis article shows you how to setup Database Mail for the first time on a new SQL Server installation.
As with many things SQL Server, you can configure Database Mail via the SSMS GUI, or you can do it using T-SQL code.
This article covers the SSMS GUI option. If you’re interested in the T-SQL option, see How to Send Email in SQL Server (T-SQL).
Continue readingIf you’re getting a “profile name is not valid” error when updating a Database Mail profile in SQL Server, it could be that you’ve forgotten to provide the profile ID.
When you update a Database Mail profile with the sysmail_update_profile_sp stored procedure, you need to include the profile ID if you want to update the profile name.
SQL Server’s Database Mail has a stored procedure called sp_send_dbmail that you can use to send emails from SQL Server.
You can use this stored procedure to send query results formatted into an HTML table.
Continue readingWhen you use the sp_send_dbmail stored procedure to email the results of a query, the column headers are included by default.
You can include or exclude the column headers with the @query_result_header argument. To remove the column headers, use @query_result_header = 0.
SQL Server has a database mail option that you can use to send mail from the database server.
For example, you can get notifications when SQL Server Agent jobs finish running or fail, or when there’s a high-severity error, etc.
Continue readingIf you find yourself needing to send an email automatically upon certain events occurring in SQL Server, you can do this via a trigger.
For example, you could automatically send an email when somebody deletes or updates a record from a table, etc.
To do this, you need to create a trigger that includes code for sending the email upon the required event.
Continue readingSQL Server’s Database Mail has a stored procedure called sp_send_dbmail that you can use to send emails from SQL Server.
By default, emails are sent as text, but you can easily change this, so that they’re sent in HTML format.
The @body_format argument is what you use to switch over to HTML format.
If you’re using Database Mail in SQL Server, you may occasionally need to stop or start the mail queue.
You can do this with T-SQL by using the sysmail_stop_sp stored procedure to stop the queue, and the sysmail_start_sp procedure to start it.
If you’ve ever used SQL Server’s Database Mail to email the results of a query, you might have noticed that the results are separated by a space by default.
This is fine if you want a space-separated result set, but what if you want it to be comma-separated?
Fortunately you can use the @query_result_separator argument to do just that. You can use this argument to specify any separator (as long as it’s a char(1)).