Send an email with an image, that is a query result, via db email

1

There is an existing email that is sent out as a step in the SQL Server Agent. I need to add an image to the email.

The code below sends the attachment, but attachment does not contain the image, only text.

I really appreciate any help.

Thank You.

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Email Alert',
@recipients = 'XXXX@XXXX.biz',
@subject = 'TV Back Temp Alarm Alert",
@Body = 'Alarm Image Attached',
@query = USE ET_Torpedo;
         SELECT TOP(1) [TVImage] FROM dbo.EmailQueBack,
@attach_query_result_as_file = 1;
2

The only sanity-preserving way to pull an image from binary stored in a database and attach it in an email is to use some external language more suited to the task, like C#, VB, python, or maybe powershell.