sp_send_dbmail 失败并带有附件

问题描述

我需要发送带有文件附件的电子邮件.附件必须来自图像类型数据字段.在查询窗口和存储过程中运行以下代码时，不会发送电子邮件.在查询窗口中，它只是说命令成功完成"，但没有电子邮件.

I need to send email with file attachments. The attachment has to come from image type data field. When running the following code in both a query window and also stored procedure, no email is sent. in query window, it just says 'command(s) completed successfully', but no email.

EXEC  msdb.dbo.sp_send_dbmail @recipients = '[email protected]',
    @subject = 'test',
    @execute_query_database = 'myDB',
    @body = 'test',
    @body_format = 'HTML',
    @profile_name = 'myProfile',
    @append_query_error = 1,
    @query = 'Select docData from [myDB].[dbo].[Documents] Where id = 1',
    @query_result_header = 0,
    @attach_query_result_as_file = 1,
    @query_attachment_filename = 'Test.doc',
    @exclude_query_output = 1,
    @query_no_truncate = 1;

删除@query时发送电子邮件:

The email is send when I remove @query:

EXEC  msdb.dbo.sp_send_dbmail @recipients = '[email protected]',
    @subject = 'test',
    @execute_query_database = 'myDB',
    @body = 'test',
    @body_format = 'HTML',
    @profile_name = 'myProfile';

但我需要附件代码才能工作.任何帮助将不胜感激.

But I need the attachments code to work. Any help would be greatly appreciated.

推荐答案

评论太长.

将 @exclude_query_output = 0 更改为 @exclude_query_output = 1.这可能会打印有关正在发生的事情的消息(错误消息).

Change @exclude_query_output = 0 to @exclude_query_output = 1. This will likely print a message (error message) on what is going on.

在您的示例中，我能够绕过错误:

In your example, I was able to get around the error:

无法初始化 sqlcmd 库，错误号为 -2147024809.

我得到了，我希望你可能会通过将 @query_result_header = 0 更改为 @query_result_header = 1 得到.我不确定为什么缺少标题会导致它失败，但它在我的开发箱上修复了它.

that I got and I expect you'll likely get by changing @query_result_header = 0 to @query_result_header = 1. I'm not sure why the lack of headers is causing it to fail, but it fixed it on my dev box.

这篇关于sp_send_dbmail 失败并带有附件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！