![]() ![]() The value must include the absolute path to the file.īy default, the maximum file size is 1 MB per file, but you can change this with the sysmail_configure_sp stored procedure. Here’s an example: EXEC = 'DB Admin = ' = 'The attached file contains all required = 'File attached as discussed' The argument allows you to specify a file to attach to the email. – This is only applicable if you’re also using to email the results of a query.– Allows you to specify a file to attach to the email.The one you use will depend on the context. This procedure accepts a bunch of optional arguments, one of which allows you to send attachments.Īctually, there are two arguments that enable you to send attachments. To send an email, use the sp_send_dbmail stored procedure. This includes a bunch of stored procedures that facilitate the configuration and sending of emails. SQL Server provides us with the ability to send emails via its Database Mail solution.
0 Comments
Leave a Reply. |