trying to figure out how to send multiple file attachments with sp_send_dbmail

Question

MSSQL 2008

Maybe i'm just looking in the wrong place. Here's the scenario:

We have files stored in a varbinary(max) column. I'd like to select these as individual files, along with the names of the files stored nearby, as individual file attachments.

can this be done?

it's easy enough to send the results of a query as an attachment, but it just sends 1 file.

Thanks

Answer 1

Based on the docs, this can't be done. You can only attach multiple files when they attached from the file system (using @file_attachments=).

Query results are always attached as a single file.