Can you send an email from SQL?

Question

SQL Server provides the ability to send emails via its Database Mail solution. The actual act of sending mail is done with the sp_send_dbmail stored procedure. But before you start sending emails from SQL Server, you need to enable and configure Database Mail. You can do this with the SSMS GUI, or with T-SQL. 2 сент. 2020 г.

Can you send an email using SQL?

Using Object Explorer in SQL Server Management Studio, connect to an instance of SQL Server Database Engine where Database Mail is configured, expand Management, right-click Database Mail, and then select Send Test E-Mail.

How do you email a SQL query?

SQL Server provides an easy way to email the results of a query to yourself (or to someone else). To send email with T-SQL, you need to use the sp_send_dbmail stored procedure in the msdb database. This procedure accepts many arguments, one of which is the @query argument.

What is SQL Mail?

Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine or Azure SQL Managed Instance. Your applications can send e-mail messages to users using Database Mail via an external SMTP server.

How do I send a query result as an email attachment?

To email the results of a query, use the @query argument. To attach those results as an attachment, use the @attach_query_result_as_file argument. This is accepts a bit value, with the default being 0 (for no attachment). To send the results in an attachment, simply provide a 1 for this argument.

Expert · Answer